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:
 

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

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,394
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2013
Platform
  1. Windows
Range("A1").Select
Application.Goto Range("A1"), True
 

Watch MrExcel Video

Forum statistics

Threads
1,133,567
Messages
5,659,574
Members
418,508
Latest member
deepakfer

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top