Pop up message

[justin.a.richie]

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

 

[Gord Dibben]

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 sheet tab and "View Code"

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

Adjust the cell range to suit.

 

[justin.a.richie]

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 sheet tab and "View Code"

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

Adjust the cell range to suit.







- Show quoted text -

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

 

[Gord Dibben]

Other than right-click on the sheet tab and select "View Code".

Copy/paste the event code into that sheet 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

 

[justin.a.richie]

Other than right-click on the sheet tab and select "View Code".

Copy/paste the event code into that sheet 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






- 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 sheet? Do I do anything with VBE? Thanks so much.

Justin

 

[Gord Dibben]

See in-line

I guess I am just confused as to where to start. I would just like
this macro to happen for when one changes.

The code will pop up the message when you make a change in the target cell.

For example if cell A1
changes,

Change A2 to A1 in the code.

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 sheet?

Just paste the code into the module that opens when you select "View Code" after
right-click on the sheet tab.

Do I do anything with VBE? Thanks so much.

The "View Code" selection opens the VBE to that sheet module.

Just close that module to go back to your worksheet. Enter anything in A1 and
the pop-up will occur.

If A1 is a calculated value which changes due to re-calculation you would use a
different type of event code.


Gord