Message Box to pop up when shipping address is entered to confirm right details...

[Legend Rubber]

I would like a message box to pop up when text is entered into the shipping address as a reminder to check correct address...

I am using

Please Login or Register  to view this content.

But this only works if it is blank... also, it comes up every time any cell is changed
I know the simple problem is right in the "IF [b12] = "" but i dont know how to fix it...
Very simple, but i am total illiterate in VBA nearly... also i only need it to do it once when something is typed in that cell...

[amotto11]

it is coming up when it is blank because you have = "", you need <>"" this says when B12 is not equal to empty then pop up the message box. It will still pop up any time anything else is populated i believe because you are reseting the workbook each time you enter something into any cell, i believe. try out the <>"" and let me know how it works for you

[Legend Rubber]

That works great, but as you say it still pops up every time i enter into any cell..
THis kind of defeats the purpose and is very annyoing... any way to avoid this? make it a specific to when B12 ONLY is changed?

[amotto11]

the only thing that i can think of would be to set a variable equal to B12 value then check everytime the sheet is changed if that variable is equal to the new B12, so i guess you could try this

Please Login or Register  to view this content.

This most likely will not work, and i will need to give it some more thought, but you can give it a shot. i think this is the right approach you will want to take, i just need to figure out the correct code

[amotto11]

you could try the worksheet_change event here in this website

http://www.ozgrid.com/VBA/run-macros-change.htm

this would be a good website as well to check it out.

http://msdn.microsoft.com/en-us/libr.../ff839775.aspx