View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] johan.lundberg-contractor@se.saab.com is offline
external usenet poster
 
Posts: 1
Default 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