| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Option window in macros
Years ago I managed to write a macro in excel that brought up a window with
a yes or no option. I have forgotton how I did that and do not have the said file anymore. What is that window called so I can look it up in the help? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Option window in macros
Hi sbmr,
I believe what you're looking for is: msgbox. Regards, GS "sbmr" wrote: Years ago I managed to write a macro in excel that brought up a window with a yes or no option. I have forgotton how I did that and do not have the said file anymore. What is that window called so I can look it up in the help? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Option window in macros
Try
Dim Res As Long Res = MsgBox("Are you sure?", vbYesNo, "Title") If Res = vbYes Then ' user clicked yes Else ' user clicked no End If -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "sbmr" wrote in message ... Years ago I managed to write a macro in excel that brought up a window with a yes or no option. I have forgotton how I did that and do not have the said file anymore. What is that window called so I can look it up in the help? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Option window in macros
Thank you, that was what I was after.
"Chip Pearson" wrote: Try Dim Res As Long Res = MsgBox("Are you sure?", vbYesNo, "Title") If Res = vbYes Then ' user clicked yes Else ' user clicked no End If -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "sbmr" wrote in message ... Years ago I managed to write a macro in excel that brought up a window with a yes or no option. I have forgotton how I did that and do not have the said file anymore. What is that window called so I can look it up in the help? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Option window in macros
Thanks.
"GS" wrote: Hi sbmr, I believe what you're looking for is: msgbox. Regards, GS "sbmr" wrote: Years ago I managed to write a macro in excel that brought up a window with a yes or no option. I have forgotton how I did that and do not have the said file anymore. What is that window called so I can look it up in the help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Haw to delete or edit Customize List in Option window in Excel | Excel Worksheet Functions | |||
| Option Buttons that use macros | Excel Worksheet Functions | |||
| In the Project window where will be the double click option | Excel Worksheet Functions | |||
| Send a String to a Web-Browser Window Using Macros | Excel Programming | |||
| De-Activating the menu option, Window - Unfreeze | Excel Programming | |||
Linear Mode
