Joshen,

How about a specific example, with worksheet names, and the process as you see it, along the lines
of

"The user selects his desired worksheet, for example "Johan Data", then the user selects sheets
"Report" and presses a button and gets the data from "Johan Data"...."

HTH,
Bernie
MS Excel MVP


wrote in message
ups.com...
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