Hyperlinks?

maxmadx

Board Regular
Joined
Aug 19, 2004
Messages
153
I have a seating plan (which looks very neat!) and was just wondering if it was possible to make so that when you click on a particular persons name (which is just in a cell), it will trigger an event that will load up a userform. So it will effectively be like a hyperlink to my userform. Is this possible in Excel?

Thanks

:)
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

tmischler

Well-known Member
Joined
Jun 17, 2004
Messages
669
You can certainly assign a macro to wordart but that is a bit messy. Another messy way of doing it would be to hyperlink to a workbook which automatically loads the form.
 

maxmadx

Board Regular
Joined
Aug 19, 2004
Messages
153
It cant be done through word art... Because Im making it so that on my seating plan, the names of people will automatically move around if u change them in the spreadsheet bit.
 

tmischler

Well-known Member
Joined
Jun 17, 2004
Messages
669
Try putting this in the worksheet code - swap the messagebox for something like

load frmUserForm1

only snag is you have to name each cell as a range.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If ActiveSheet.Range("James") = ActiveCell Then
MsgBox "ok"
Else
End If
End Sub
 

Watch MrExcel Video

Forum statistics

Threads
1,130,112
Messages
5,640,174
Members
417,130
Latest member
Darion2021

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top