![]() ![]() This article contains more info and a video on how to keep the drop-down arrow always visible. The great part about this is that the user does not have to move the mouse cursor to select the cell to the left. This means when the user clicks the fake drop-down cell, the cell with the validation list will automatically be selected and the user can select from the list. The suggestion was to use put a hyperlink in the fake drop-down cell that points to the cell to the left that contains the data validation. ![]() ![]() I received an awesome suggestion from the TheCric1 on the YouTube video comments about an alternative to the Input Message for the fake cell. Please see the video above for further details and instruction. When the user selects the cell to the left that contains the list, the real drop-down icon will appear. This will create the drop-down icon in the cell and give it a disabled appearance. Border Color = Grey, Border Width = Single.Format the cell with the following properties:. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |