Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
make message box appear when cell is clicked?
Learning vba as I go, right now I am trying to get a message box to appear on
a user form I created for staff. This is what I have so far: Sub showMessage() MsgBox "Press Alt-Enter to insert a new line" End Sub What would the rest of this code be to have the message pop up when merged cell AE8 is selected? Thanks in advance :) Trina |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
make message box appear when cell is clicked?
Right click sheet tabview codeinsert thisDOUBLE click in e8:f8 to fire
Private Sub Worksheet_BeforeDoubleClick _ (ByVal Target As Range, Cancel As Boolean) If Target.Address < Range("e8:f8").Address Then Exit Sub MsgBox "hi" End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "Tacrier" . wrote in message ... Learning vba as I go, right now I am trying to get a message box to appear on a user form I created for staff. This is what I have so far: Sub showMessage() MsgBox "Press Alt-Enter to insert a new line" End Sub What would the rest of this code be to have the message pop up when merged cell AE8 is selected? Thanks in advance :) Trina |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make a box with a check mark when clicked? | Excel Worksheet Functions | |||
How to make a checkbox on a chart invisible when it is clicked? | Charts and Charting in Excel | |||
how can I make an excel cell "mark" or "unmark" when clicked on? | Excel Discussion (Misc queries) | |||
Change cell value when right-clicked/double-clicked | Excel Programming | |||
in a excel file, how to make a menu item for the .xls file that when clicked on it runs myform.show? example plz | Excel Worksheet Functions |