Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel Programming

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 09-06-2017, 02:55 PM
sahara sahara is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Sep 2017
Posts: 3
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 Windows Vista 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 Windows 7 64bit Office 2013
Novice
 
Join Date: Sep 2017
Posts: 3
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 Windows 8 Office 2016
Advanced Beginner
 
Join Date: May 2017
Posts: 85
ArviLaanemets is on a distinguished road
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 Windows 7 64bit Office 2013
Novice
 
Join Date: Sep 2017
Posts: 3
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

Thread Tools
Display Modes


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


All times are GMT -7. The time now is 05:06 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft