Help

I'm populating a list box with values from my worksheet which is easy enough. But what do I need to do so that If I click on a value on the list box I can activate a macro that will change sheet

For example...I have 7 sheets for 7 days. I want the same drop down list on each sheet that will allow navigation between the sheets

Any help appreciated

GC

GC,

Is this a Forms Listbox? If so, right click on it to assign a macro, and
also to define a link cell. In the macro you can get the value from this
link cell like so

Worksheets(1).Range("A1").Value

To navigate the sheets

Worksheets(Worksheets(1).Range("A1").Value).Activa te

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Novice" wrote in message
...
Help!

I'm populating a list box with values from my worksheet which is easy
enough. But what do I need to do so that If I click on a value on the list
box I can activate a macro that will change sheet.

For example...I have 7 sheets for 7 days. I want the same drop down list
on each sheet that will allow navigation between the sheets.

Any help appreciated.

GC