Hyperlinks?

[maxmadx]

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

 

[tmischler]

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]

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]

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