Need to update a ComboBox when selecting a sheet
Hello all
I have a workbook with several worksheets.
The sheets contain data that will be updated during normal work.
When data is to be extracted a special sheet is opened/ selected.
When this is done the information in the combo-box needs to be updated
with the information from the data sheets.
Then by selecting the appropriate data the required calculations can
be done.
I have tried all I can find on the net, but I have not been successful
to run some action when a specific worksheet is selected.
Would appreciate all help you can get me.
//Joshen
|