VBA hyperlink

Folks,
I understand how to use the hyperlink function, but I have been struggling with the VBA format. Here's my function:
=HYPERLINK("[Excel Formulas and Functions.xlsm]Textfunction!A1","Numeric Values")

Open in new window

I need help on the VBA dise since I'll be using a command button rather than a function.
Frank FreeseAsked:
Who is Participating?
 
mvidasConnect With a Mentor Commented:
Hi fh,
Worksheets("sheet name").Activate
Range("A1").Activate 'if you want a specific cell seen

Open in new window

Matt
0
 
unknown_routineCommented:
put this code behind the button:


Dim oExcel as Excel.Application
Dim oWB as Workbook
Set oExcel = new Excel.Application
Set oWB = oExcel.Workbooks.Open(<pathToWorkbookHere>)
0
 
Frank FreeseAuthor Commented:
I meant to also state that this link is in the same workbook.
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
Frank FreeseAuthor Commented:
Folks,
The more that I think about this "hyperlink" is really a poor choice. All I am wanting to do is have a command button coded to go to a specific worksheet in my workbook. I apologize for confusion.
0
 
Frank FreeseAuthor Commented:
mvidas,
that worked just fine. I have a follow-up question coming
0
 
Frank FreeseAuthor Commented:
good job
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.