| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
cell link to userform
Is there a way to either click or doubleclick on a cell and have it start a
userform? Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
cell link to userform
Put this code into the sheet that you want it to work on.
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) If Target.Address = "$A$1" Then frmMe.Show end sub Which would then load the userform frmMe when cell A1 is clicked "ranswrt" wrote in message ... Is there a way to either click or doubleclick on a cell and have it start a userform? Thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
cell link to userform
Will that work if the cell is locked? I don't want the data to be changed in
the cell. "Graham Whitehead" wrote: Put this code into the sheet that you want it to work on. Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) If Target.Address = "$A$1" Then frmMe.Show end sub Which would then load the userform frmMe when cell A1 is clicked "ranswrt" wrote in message ... Is there a way to either click or doubleclick on a cell and have it start a userform? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Link value from a Cell to a control in the userform | Excel Programming | |||
| Link from Userform to Spreadsheet | Excel Programming | |||
| Userform w/ Multiple listboxes that link | Excel Programming | |||
| Userform w/ Multiple listboxes that link | Excel Programming | |||
| how do I link Textboxes in a userform to a Cell in a Worksheet? | Excel Programming | |||
Linear Mode
