Re: Pop up message

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

On Jun 13, 6:31 pm, Gord Dibben <gorddibbATshawDOTca> wrote:
Other than right-click on the *** tab and select "View Code".

Copy/paste the event code into that *** module.

As written, when you make a change in A2 the message will pop up.

What assistance do you require?

Do you need a different or larger range or an entire column or row or??

You need to provide a few questions about what more you require before I can
provide more detail.

Gord



On Wed, 13 Jun 2007 14:52:16 -0700, justin.a.ric...@xxxxxxxxxx wrote:
On Jun 13, 5:18 pm, Gord Dibben <gorddibbATshawDOTca> wrote:
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
On Error GoTo stoppit
Application.EnableEvents = False
If Target.Address = "$A$2" And Target.Value <> "" Then
MsgBox " Please be advised that this amount does not include blah blah amount."
End If
stoppit:
Application.EnableEvents = True
End Sub

Right-click on the *** tab and "View Code"

Copy/paste the above event code into that *** module.

Adjust the cell range to suit.

On Wed, 13 Jun 2007 13:53:21 -0700, justin.a.ric...@xxxxxxxxxx wrote:
Hello All,

I am looking to create a popup warning notification macro when a cell
is changed. I would like it to say something like this: Please be
advised that this amount does not include blah blah blah amount. Does
anyone know how to create this Macro?

Thanks so much- Hide quoted text -

- Show quoted text -

I am very very new to this. Can you go into more detail as to what to
do? thanks so much- Hide quoted text -

- Show quoted text -

I guess I am just confused as to where to start. I would just like
this macro to happen for when one changes. For example if cell A1
changes, I would like a notification to appear saying this cell is
changing. Do I just start off by pasting that entire code into the
View Code ***? Do I do anything with VBE? Thanks so much.

Justin

.

Quantcast