Confirmation Msg Popup

[Rage]

Hi all

I need a little help implementing a confirm popup msg.

I have this code and would like that when you change the Target.Value it would pop a confirmation box with yes or no option.

I know how to implement this for a button, but cant figure how do i do it with this code.

Thanks in advance

Please Login or Register  to view this content.

[Rage]

Nevermind i figured it out.

Thanks anyway

[dominicb]

Nevermind i figured it out.

Thanks anyway

Hi Rage

Glad you're sorted. Why not post your solution so that other users may benefit from it.

Also, please take a moment top mark your thrread as "solved".

DominicB

[DonkeyOte]

Rage, you need to be careful with how you use Events / Exit Subs etc... problems are avoided here because the Intersect is constant meaning the mid-routine Exit Sub (with events disabled) will never invoke... should it and you would have a problem

I would say from looking at the code you could consider condensing along the lines of the below (ignoring your msgbox dialog which you say you have handled):

Please Login or Register  to view this content.

(Note: I also used Canceled rather than Cancelled)

[Rage]

I Just searched a bit on the forum for possible solutions

and came up with the simplest of them :P

Please Login or Register  to view this content.

Inserted this code on begining of mine, and voila it works in perfection :P

[Rage]

Thanks Donkeyote for reviewing my code.

Since im not an expert in VBA and im still learning i just go along with what i find and then try to mange it into my sheets.

But +10 for your quick answer.