MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Help with my first dropdown box, please

Posted by Deborah Morera on September 04, 2001 6:40 AM

I have created a dialog box that has a drop down box displaying the months of the year. For the first part of this program I simply want to be able to display the month chosen by the user in a particular cell. I am having trouble understanding how to use .list and .listindex...any suggestions?

Thanks in advance!

Posted by brent on September 04, 2001 2:28 PM

Have you tried:
let's say the dialog box is in $B$1 and the cell that you want the month to come up in is $C$1
in C1 enter =+$B$1