go to cell

[riles]

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.

 

[Mr_Roscoe]

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]

Range("A1").Select
Application.Goto Range("A1"), True