Combo Box with Links (to names/cells)

NewYears1978,

Attached is an example workbook based on the criteria you described.

There is an ActiveX ComboBox in cell B2, (I resized row 2 and column B so that it would fit).
The combobox's linked cell is A2, so whatever is chosen from its list will appear in cell A2.
The combobox's ListFillRange is J2:J3
In column J are the names of the two named ranges I created as a test. They are Name1 and Name2 in cells J2 and J3 respectively.
Cell A1 is this formula to get the workbook name:

Please Login or Register  to view this content.

Then in cell C2 is this formula to create the hyperlink to the chosen named range:

Please Login or Register  to view this content.

You'll notice that when you click on the hyperlink you go to the sheet of the named range and have its cell selected. Name1 goes to Sheet2!$A$1 and Name2 goes to Sheet3!$B$2. You can hide column A if you'd like, as it is really just a helper column. Is something like that what you're looking for?

Thanks! I will look at it and see if I can figure it out..really an excel newbie..using Macros and such is all new to me

Is there a way to make it auto jump on selection? Not entirely necessary but will be nice if possible. I am trying to tweak you example to work..as it will do what I nee, if I can figure out how to implement it in my workbook :P

NewYears1978,

Originally Posted by NewYears1978

Is there a way to make it auto jump on selection?

This can only be accomplished with VBA. I was avoiding it because you requested to not use VBA if possible (which is a good thing I think); however, if you want this functionality and are ok with the VBA code it will come with, I can provide that.

NewYears1978,

You can put the spaces in the list so that the list items in the combobox will have spaces. Then use the formula in C2 to remove the spaces:

Please Login or Register  to view this content.