![]() 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:.Press the Insert button, then the Close button.Find the symbol that looks like the down-arrow.On the Symbol window, choose “ Wingdings 3” from the Text drop-down.Go to the Insert tab on the ribbon, press the Symbol button.Select the cell to the right of the cell that contains a validation list.Then format the cell to look like like a disabled drop-down arrow icon. You can do this by placing a Wingdings 3 character in the cell to the right. One possible solution is to create a fake drop-down icon in the cell to the right of the cell that contains the validation list. This means the user won’t necessarily know that there is a drop-down list for them to choose from. The problem is that the drop-down icon arrow disappears when the user selects a different cell. Clicking on this icon allows them to make a selection from a list. When a user selects the cell that contains a drop-down list, a small icon appears to the right of the cell. Problem: The Drop-down List Arrows Disappearĭrop-down lists in a cell (also known as validation lists) are a great way to make your Excel model interactive. ![]() ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |