Creating a drop down list in excel
Posted by Randycas on June 22, 2001 6:15 AM
I have been trying to create a drop down list in excel using visual basic for a while now. I know absolutely nothing about this application.
Basically what i want to do is have a drop down list for each cell in a column where the user selects a mortgage company and a code would be shown. I have gotten as far as creating the 2 column list and designating the bound column, then I tried to write code to show the drop down arrow and list when the user selects the cell but i am not having any luck at all. This is very new to me and I would appreciate any help with this since this is the only item on the worksheet giving me trouble and my deadline went about 2 weeks ago.
Thanks for your help