Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Message Box
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". |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Message Box
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) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Message Box
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? -----Original Message----- 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) . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pop-up message | Excel Discussion (Misc queries) | |||
Message Box | New Users to Excel | |||
Pop up message | Excel Discussion (Misc queries) | |||
changing the message in an error message | Excel Worksheet Functions | |||
Displaying a message in a message box without requiring user to click anything to proceed | Excel Programming |