cell message prompt

bronwyn

Board Regular
Joined
Jun 12, 2004
Messages
93
hi again all, what i want to do seems fairly simple, but i cannot work out how to display a message when a particular cell is clicked/selected on a worksheet, any help as always most appreciated
 

Some videos you may like

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650
Right click the sheet tab, select View Code, paste in the following

Code:
Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address(0, 0) = "A1" Then MsgBox "You clicked A1"
End Sub

Substitute A1 with the address of the cell you want the notification for.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,205
Messages
5,527,402
Members
409,760
Latest member
zeeshansyed

This Week's Hot Topics

Top