Hi,

I have a problem that I can resolve in two ways.

1) Is that I have a formula that will run a certain macro only if a
defined cell is a certain number. IE, if A1=1 then run macro1.. if A=2
then run macro2.. if A1=3 then run macro3.. etc

2) I have a combo box with 15+ options in. Is there a way that I can
assign a macro to the invidual options? Or to assign a function to be
carried out if a user clicks on a certain option?

If there is a way to do either of these, then I would be very grateful
if you could explain how. Otherwise, are there any other methods that
could possibly do the same thing?

The scenario is:

I have a combo box with X amount of activities that an organisation
offers. I want a user to navigate the spreadsheet using this combo box.
Clicking on the activity in the combo box will take the user to the
corressponding activity page.

Thanks in advance.


---
Message posted from http://www.ExcelForum.com/