Copy Results of ComboBox from 1 Worksheet to Another

[rbrookov]

Howdy,

I have a macro that makes copies of a worksheet based on user input. Then, once the user types a Part Number into a specific cell & clicks "Save" - the macro also saves that workbook with the filename of the Part Number (for instance, if the user types "ABCD" into the Part Number cell & clicks "Save" then the macro saves the file as ABCD.xlsm).

That all works as desired.

I also have a macro whereby if the user changes the Part Number and a few other cells (including a combobox selection), then clicks "Save" again - the macro loops over all worksheets & copies the data which has changed from the 1st Worksheet to all other worksheets. (For instance, if the user changes the Part Number to "ABCDE" - then clicks "Save" - the macro copies the "ABCDE" to all other worksheets, as well as saves the file as ABCDE.xlsm

The code for that macro is here:

Please Login or Register  to view this content.

That macro works as desired as well - EXCEPT that the last commands (the copying of the Combox2) does NOT work.

How can I get the code to also copy the results of the combobox, such that if the user changes the selection in the combobox on the 1st sheet, the selection gets copied & updated on all other sheets?

Thanks in Advance,
Rob

[stnkynts]

A ComboBox is not a range. It is an object and as such needs to be treated that way. There are two types of comboboxes so the answer to your question could be either one:

ActiveX:

Please Login or Register  to view this content.

FormControl:

Please Login or Register  to view this content.

[rbrookov]

stnkynts,

Thank you for the explanation & the code... but I (sheepishly) have a stupid question... how do I know which ComboBox I have: ActiveX or FormControl?

Thanks,
Rob