Message Box

[Powlaz]

Is there a way to incorporate a message box into a
simple "If" statement? I don't know enough to use vbcode
with Excel. I just use the built in functions. I need
to incorporate a message box into one of my "if
statements".

 

[David C.]

I need
to incorporate a message box into one of my "if
statements".

Well, i do not really understand the point.
do you want to test the result of the button clicked ?

Because if the problem is just to open a box under conditions it's easy:

if (condition) then
msgbox "condition true"
end if

else, the msgbox can be read
result = msgbox ( "yes or no ?", vbYesNo)
msgbox result

and the help of msgbox will give you all the possible values (vbYes or vbNo
for example)

 

[Powlaz]

I see what you are saying but I do not go to the code
page to make things happen. I'm not very well versed. I
select a cell and then chose a function. It is from here
that I wanted the message box to be programmed in. Is
this possible?