#1
|
|||
|
|||
create a clickable text box to jump to a range of cells
working on an Excel file. need to create a text box (basically the text box to say "click here for directions") that can be clickable to jump to a range of cells that has the actual directions. Help please. |
#2
|
|||
|
|||
Is the textbox on a VBA UserForm or a textbox created using the Developer Tab? What is the textbox going to contain? Cell reference or something else?
|
#3
|
|||
|
|||
This is a regular Excel file. No VBA/developer tab. Just created a box with some merged cells to put the description of the excel file content right at the top. want to give a description of the directions in another merged text box at the bottom.
The viewers of this excel file will have a choice to click on the "click here for Directions" in the top text box in the merged cell box and go to the bottom text box in the merged cell box of the same worksheet. Please help |
#4
|
|||
|
|||
No need for VBA and textbox - use hyperlink in some cell at top of sheet instead.
I think you have to define the hyperlink destination as bookmark, to move the cursor to cell range. |
#5
|
|||
|
|||
Yes I was able to create the hyperlink in a cell. Thank you. Great tips!!
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Distribute text in one cell across a range of cells (overcoming selection.range.cells.count bug) | slaycock | Word VBA | 0 | 02-18-2017 07:00 AM |
Copying text range of cells to different cells adds an extra line | jpb103 | Word VBA | 2 | 07-23-2014 12:22 PM |
Color-fill a range of cells, based on text in a different sheet. Possible? | unittwentyfive | Excel | 2 | 06-01-2014 06:48 AM |
Word 07 won't create clickable links sometimes | baffled | Word | 4 | 01-08-2014 10:53 PM |