Hi,

I have an Excel workbook which had worksheet's own form objects and also
objects created with VBA's control toolbox.

Specifically I have a drop down form object called DropDown6 (I see no way
of changing the name). In my VBA code, I want to capture the data the user
had previously picked from this drop down & do further processeing with it.
I know that I can assign a macro to the dropdown, but I want to do other
things which are to be triggered by a separate command button.

Is it possible to use a VBA command to capture the data the user had
previously picked in this drop down?

Regards...