List Box properties

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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).Activate

--

HTH

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

Novice said:
Help!

I'm populating a list box with values from my worksheet which is easy
Click to expand...
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
Click to expand...
on each sheet that will allow navigation between the sheets.
 
Back
Top