Hello. This is my first post on here. I have almost no knowledge of VBA programming other than what I have learned whilst trying to research a solution to my problem.
I have a cell that contains a drop down list of 5 items. I also have 5 text boxes. Depending on which item is selected from the drop down list I would like the corresponding text box to display (and the other 4 to be hidden). i.e. first item in the list is selected then text box 1 will appear, second item in the list is selected then text box 2 will appear and so on.
How do I achieve this? Also, can this be achieved by using 'normal' text box since the formatting options for activeX text boxes seems to be very limited? Everything is just in a simple worksheet.
Any help/guidance would be much appreciated!
Bookmarks