OK, so I have a problem. I have a long list (about 75 items) I would like to have available from a drop down list. Then, depending on which item was selected a specific string of text would appear in another spot. So, I'm thinking VBA, of course. I just don't know where to start... combo box? I tried the drop down box (forms) but it has a limit on the number of characters for each item in the list which turned out to be insufficient for what I have.
Any tips would be super mega appreciated!