Trying to add simple VBA code on one cell and it's applying to whole sheet!!!

[sfranklin]

Can someone please help? I have a sheet and am trying to add a VBA code that triggers a pop up message if a person enters a number in cell E5 that is less than 0.5. I have the following code entered in the Microsoft Visual Basic for Applications:

Private Sub Worksheet_Change(ByVal Target As Range)

If Range("$E$5").Value < 0.5 Then MsgBox "This is wrong"

End Sub

It seems to be working, as when I enter a value in E5 that is less than 0.5 that alert comes up. However, the alert comes up for every single cell in the spreadsheet when I enter a value less than 0.5. I thought I had restricted it to cell E5 in the coding.

Could someone please help me and let me know what I am doing wrong? THANK YOU!!!!

[bakerman2]

Welcome to the forum. Please use Code Tags when posting code. (check Forum Rule #2)

Please Login or Register  to view this content.

[Trebor76]

Another (just slightly different) way:

Please Login or Register  to view this content.

Regards,

Robert

[sfranklin]

that worked!!! thank you!!!

[sfranklin]

Any ideas why this isn't working now? I have attempted to add tags...I hope these are correct! When I enter this into the Microsoft Visual Basic for Application, save, and then test in the excel I'm getting the attached pop up as an error and I don't know what needs to be fixed! THANK YOU!!!

Please Login or Register  to view this content.

[bakerman2]

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

Requested code tags added by moderator, as the OP is new.

What isn't working ? When testing the msgboxes come up just fine

[Marc L]

Hi !

A code is useless just using the Excel Data Validation ! …

[sfranklin]

Can you have the message box pop up with data validation? I thought for the message box I need to do VBA coding. Thanks!!

[bakerman2]

Please Login or Register  to view this content.

[Marc L]

Can you have the message box pop up with data validation?

Yes, it's an Excel Basics …