First thing I saw on the graphic above was three question marks, and immediately related that to using non-Roman fonts (as I deal with Korean users/operating systems/file names/dialog boxes on a daily basis).

Recommend you spell out the question in the MsgBox – at least for the title. I’ve screwed up more than once by agreeing to something I shouldn’t have.

(I realize that this is a quick demonstration of if…then and not language incompatabilities.)

…..i have this code but evertime i click No buttong in the message box it still open me a form… please help me if there is still missing in my codes and what was it?…Im not a programmer, anyone can help with this code?

MsgBox title:=”Analysis of Acctg Activities”, Prompt:=”Can not execute your command. No data availabe for that period.”

End Sub

When run this code it jumps to the conclusion. “Wrong number of orgumaents or invalid property assignment” and shows the MsgBox. I ran this code before several times without any problem. Now I am using Excel 2007.

Can u write a programm or steps for writting a programm in macros in which there is a formula with variable value “x” such that when you put the value “x” the answer should match exactly to other cell value.
As i am new and not knowing the code & steps for writting a programm.
help me out