Results 1 to 2 of 2
2002-12-06, 09:38 #1
- Join Date
- Feb 2001
- Thanked 0 Times in 0 Posts
Go to a cell based on selection from listbox (Excel 97)
I have a couple of tables in a worksheet and rather than making buttons for each table with a caption 'Go to next' or 'previous', I would like to have a list box (or combo box) where the user can select (the listbox should be populated with the content of various cells, each one being the a title for the respective table) which table to jump to.
Is there any way I can do this, with or without a macro?
2002-12-06, 10:06 #2
- Join Date
- Mar 2002
- Thanked 29 Times in 29 Posts
Re: Go to a cell based on selection from listbox (Excel 97)
The easies solution is probably to create a series of hyperlinks in cells. Enter a descriptive text in a cell, then select Insert/Hyperlink. Leave the top (File/URL) box empty, and type the address of the table you want to jump to in the lower (Named Location) box. If the table is in a different worksheet, include the sheet name, e.g.
If you want a combo box, have a look at <post#=188299>post 188299</post#> by sdckapr. Steve has attached an example to that post.