VBA to Confirm Change of Populated Cell Content

[LEEPRIESTENATOR]

Hey there

Need some help here. I need some code in "Worksheet_Change" to essentially confirm if a user wants to change the content of a populated cell.

I found some code by royUK helping with another user's request and this works perfectly except that it also fires up the message box when trying to put information in a blank cell.
I need the confirmation box to come up only when trying to change a populated cell, not a blank cell.

I've attached the code by royUK with small edits based on my requirement. I've got [If Target.Value <> "" Then] in there, but I'm sure I'm doing something wrong which is why it isn't working (ie. still pops up on change of any cell, including blanks).

Please Login or Register  to view this content.

Also, if it's not too much trouble, I'd like something similar for "Worksheet_SelectionChange" where

Condition: if the cell is populated and a user clicks on it,
Options: it throws out a box with 2 options "Yes" and "No"
Yes = the cell is selected
No = Select the first empty cell in Column B

BTW - You guys are awesome. Cheers.

[Cofad]

Do you want to check if a cell is populated before selecting the cell? Or do you want to confirm a change after text is entered into a cell?

[LEEPRIESTENATOR]

Ok let me explain.
I need two pieces of code, both targeting different ranges and for different purposes. The first one in "worksheet_change" as illustrated in the code above, to trigger when a populated cell's content is being changed.

The second, a similar code under "worksheet_selectionchange" to trigger when a user clicks on a populated cell only.

Both codes must leave empty / blank cells alone.

For the first code, after the change is detected, the code initiates a message box with two options, yes and no. Yes = save the changes, No = revert to previous value.

For the second code, as soon the user selects a populated cell, the code puts out a message box with two options, yes and no. Yes = leave the cell selected, No = Make the first empty cell in column B, the Active Cell.

[LEEPRIESTENATOR]

Thread Bump. Really hoping you guys can help with this one.

[LEEPRIESTENATOR]

Really need some help with this. I haven't been able to figure this out so far as my VBA are almost non-existent

[Cofad]

Try this:

Please Login or Register  to view this content.

I'm not 100% sure how you want it to work, but this is the best I could figure

[LEEPRIESTENATOR]

You sir, are a god send. Thank you. I'll check it and get back to you.