go to cell

riles

New Member
Joined
Mar 31, 2010
Messages
3
I am trying to incorporate a "GO TO" feature in a package. This can be seen on the front page of this site.

A list box with pages to go to and a go button. (or I have seen it without the button)

Any help is appreciated.:confused:
 

Some videos you may like

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Mr_Roscoe

Board Regular
Joined
Mar 28, 2006
Messages
200
Riles - when you have a list box the items in the list are numbered in sequence. What I mean is the item at the top of the list (or list header) is 1, the next item in the list is 2, etc

So a list box can be linked to a cell to show what item in the list has been selected.

For example, the list box could be linked to cell A3. When the user has selected the fourth item in the list this creates a value of 4 in cell A3.

A "Go To" button should be used to initiate a macro that sends the user wherever they need to get to based on the value in cell A3, something like:

If Range("A3").value = 1 then
Sheets("Sheet 1").Select
Range("B17").Select
If Range("A3").value = 2 then
Sheets("Sheet 2").Select etc

Trust this helps, Ian R.
 

bobsan42

Well-known Member
Joined
Jul 14, 2010
Messages
1,343
Range("A1").Select
Application.Goto Range("A1"), True
 

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,106,414
Messages
5,511,198
Members
408,829
Latest member
sheshe123

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top