VBA messagebox

[TheMagician]

Hello everybody,

I want to create a VBA-for my worksheet wich performs the following action.

When the value of a specific cell changes i want a messagebox wich asks the user to check the value in the cell.

Hope somebody can help me.

thanx

[sktneer]

Hi,
Welcome to the Forum.

Based on your description, place this code on Sheet Module.
Right click on the Sheet Tab --> View Code --> Paste the below code in the opened code window.

Assuming your specific cell is A1, then try this.....

Please Login or Register  to view this content.

[TheMagician]

You are Brilliant!

Can you help me a little more?

I want the first message box to ask if the value is correct, if 'yes' no further action. If 'no', i want a message box to just display a message.

[sktneer]

Maybe this.....

Please Login or Register  to view this content.

Paste the above code on Sheet module as explained earlier.

[TheMagician]

You are genius....

one more question.

If A1 changes cause of a formule in A1 it won't work. Is there a solution?

[sktneer]

In that case you can use the reference cell used in formula as a Target cell. Say A1=B1*10 and if B1 changes, A1 will also change. Therefore using this logic, you can track the change in A1. Of course the code will change to have B1 as Target cell this time.

[TheMagician]

Thanx u very very much!

Were u from?

[sktneer]

You're welcome.

I am from India as you can check that in my profile.

If that takes care of your question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.

[TheMagician]

ah india! Well if i can help u, what probably wont happen with excel or VBA you're welcome!

[sktneer]

Thanks. Take Care.

[TheMagician]

one more question again... i'm sorry!

Is there a possibilty to determine the possition of de messagebox? for example a little lower in the screen?

[sktneer]

I don't think that it is possible with VBA Msgbox as the MsgBox function doesn't include any way to specify a location.

[TheMagician]

Oke anyway Thanx!