Still having trouble with my drop down box...
Posted by Deborah Morera on September 05, 2001 5:06 PM
Ok, here's what I have done..if someone could point me in the right direction I would appreciate it. I have created a dialog box that contains a drop down box (combo box) that shows the months of the year. What I would like to happen when the user selects a month is for the column containing that month's name to be copied and pasted to a new spreadsheet. How do I assign the data from the dropdown box to a variable I can use later in the code? I have tried using .list and .listindex but I get error messages so i must not understand how to use them correctly.
I am still fairly new to this VBA programming game (started learning it this weekend actually) I have managed to write code to set up new clients, I just want to add code that will print out monthly reports. Any help would be appreciated.
Thanks in advance.