 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / May 2008Hyperlink to a userform?
I have a macro that assembles a series of user workbooks from a template library, and some cells have hyperlinks that are constructed based on user data entries. I now have a need to give the user a choice of hyperlink from certain cells, and my plan is to provide a userform to handle that. Is it possible to create a hyperlink to the userform, or do I have to emulate it by using a selection change event?  SignatureAl C This should work. just change cell reference to the cell that has your hyperlink Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink) If Not Intersect(Target.Parent, Range("c9")) Is Nothing Then MySub 'sub to open userform or just userform.show End If End Sub > I have a macro that assembles a series of user workbooks from a template > library, and some cells have hyperlinks that are constructed based on user > data entries. I now have a need to give the user a choice of hyperlink from > certain cells, and my plan is to provide a userform to handle that. Is it > possible to create a hyperlink to the userform, or do I have to emulate it by > using a selection change event? Yes. That would work if I could enter the code by hand, but I need to have the macro create the links dynamically after the user enters data, and I can't know in advance even which cells need the multiple links. I can have the macro set up a range and populate it with the appropriate hyperlink names, link the controls to those names, adjust the userform so only the live controls are accessable, and access the userform through the event handler, but I'm looking to see if there is an easier way to get there. SignatureAl C > This should work. just change cell reference to the cell that has your > hyperlink [quoted text clipped - 11 lines] > > possible to create a hyperlink to the userform, or do I have to emulate it by > > using a selection change event? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.