• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to have my combo box go to a cell when selected

R

rjwalters

New Member
In A1 I have combo box with my list in it. I want it go to a certain cell when that cell is referenced.


Example:

My combo box says A6, and when I select this from the combo box, I want it to go to cell A6.


I have tried hyperlinks but I cannot get them to work in the combo box.

I do not understand why my box does not do anything.
 
RJWalters


Combo boxes return an Index Number to a cell

How you use that is up to you

You can also link a Combo Box to some VBA Code

and by doing this you can retrieve the index value and the VBA code can change the active cell for you

Can you post a sample file for us to see and assist you with ?
 
You must log in or register to reply here.
Back
Top