I have put in my worksheet a drop down box using the forms toolbar in excel. I have populated the drop down with a list in excel. I now want to add a change macro so that when I change the value of the drop down box it will make changes within the sheet. What I can\'t figure out is the name of the dropdown box, the default marco name is dropdown32_change() but if I use x = dropdown32.text or x = dropdown32.value excel gives a object required error. How do you referance the value of the dropdown box?
\r\n
\r\nThanks in advance.