Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page create a clickable text box to jump to a range of cells
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 09-06-2017, 02:55 PM
sahara sahara is offline create a clickable text box to jump to a range of cells Windows 7 64bit create a clickable text box to jump to a range of cells Office 2013
Novice
create a clickable text box to jump to a range of cells 		 
Join Date: Sep 2017
Posts: 4
sahara is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 09-07-2017, 05:11 AM
Trevor G Trevor G is offline create a clickable text box to jump to a range of cells Windows Vista create a clickable text box to jump to a range of cells Office 2007
Novice
  
Join Date: May 2012
Posts: 9
Trevor G is on a distinguished road
Default
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?
Reply With Quote
  #3  
Old 09-07-2017, 06:24 AM
sahara sahara is offline create a clickable text box to jump to a range of cells Windows 7 64bit create a clickable text box to jump to a range of cells Office 2013
Novice
create a clickable text box to jump to a range of cells 		 
Join Date: Sep 2017
Posts: 4
sahara is on a distinguished road
Default
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
Reply With Quote
  #4  
Old 09-07-2017, 07:36 AM
ArviLaanemets ArviLaanemets is offline create a clickable text box to jump to a range of cells Windows 8 create a clickable text box to jump to a range of cells Office 2016
Expert
  
Join Date: May 2017
Posts: 873
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default
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.
Reply With Quote
  #5  
Old 09-07-2017, 10:56 AM
sahara sahara is offline create a clickable text box to jump to a range of cells Windows 7 64bit create a clickable text box to jump to a range of cells Office 2013
Novice
create a clickable text box to jump to a range of cells 		 
Join Date: Sep 2017
Posts: 4
sahara is on a distinguished road
Default
Yes I was able to create the hyperlink in a cell. Thank you. Great tips!!
Reply With Quote
Reply

« Previous Thread | Next Thread »


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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:52 AM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft