Snoopy22
02-02-2012, 04:58 AM
Hi All,
I am working in a spreadsheet (not a User form!) in Excel 2003.
What I would like to do is select and activate an entry of a Combobox by a VBA macro. I need this to run a large model in different scenarios, i.e. select Combobox entry 1 Base Case, calculate, copy data from one sheet and paste hadplugged values in another sheet, select Combobox entry 2 Best Case, calculate, copy data from one sheet and paste hadplugged values in another sheet, select Combobox entry 3 Worst Case, calculate, copy data from one sheet and paste hadplugged values in another sheet.
Everything works fine by using the macro recorder except the selection of the combobox item...
Thank you for your help in advance!
I am working in a spreadsheet (not a User form!) in Excel 2003.
What I would like to do is select and activate an entry of a Combobox by a VBA macro. I need this to run a large model in different scenarios, i.e. select Combobox entry 1 Base Case, calculate, copy data from one sheet and paste hadplugged values in another sheet, select Combobox entry 2 Best Case, calculate, copy data from one sheet and paste hadplugged values in another sheet, select Combobox entry 3 Worst Case, calculate, copy data from one sheet and paste hadplugged values in another sheet.
Everything works fine by using the macro recorder except the selection of the combobox item...
Thank you for your help in advance!