Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
OnClick event
Hi guys,
I would like to ask you a question. I would like to prompt a user with a message ( inputbox) when the click in a specific cell. How can I do that? Thanks in advance Riri |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
OnClick event
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$H$1" Then MsgBox "hello" End If End Sub 'This is worksheet event code, which means that it needs to be 'placed in the appropriate worksheet code module, not a standard 'code module. To do this, right-click on the sheet tab, select 'the View Code option from the menu, and paste the code in. -- HTH RP (remove nothere from the email address if mailing direct) "lilika" wrote in message om... Hi guys, I would like to ask you a question. I would like to prompt a user with a message ( inputbox) when the click in a specific cell. How can I do that? Thanks in advance Riri |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
OnClick event
Thanks a lot in works like magic
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
OnClick | Excel Discussion (Misc queries) | |||
dynamic hyperlink or onclick event | Excel Programming | |||
onClick in Excel | Excel Programming | |||
onclick event for cell | Excel Programming | |||
range onclick? | Excel Programming |