| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom Dialog Box Macro for Excel
I have created a custom dialog box in VB, to be used as a macro in Excel. So
far, when I run the macro, the box opens, and prompts the user to answer a question by clicking yes or no. When they click the button, a task is performed. I can not figure out how to automatically close the dialog box, once the user has clicked the 'Yes' or 'No' buttons though. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Custom Dialog Box Macro for Excel
hi
add this to the end of your button code possible to both yes and no buttons. unload me Regards FSt1 "floyd,p" wrote: I have created a custom dialog box in VB, to be used as a macro in Excel. So far, when I run the macro, the box opens, and prompts the user to answer a question by clicking yes or no. When they click the button, a task is performed. I can not figure out how to automatically close the dialog box, once the user has clicked the 'Yes' or 'No' buttons though. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Custom Dialog Box Macro for Excel
That seemed to work.
Thank You. "FSt1" wrote: hi add this to the end of your button code possible to both yes and no buttons. unload me Regards FSt1 "floyd,p" wrote: I have created a custom dialog box in VB, to be used as a macro in Excel. So far, when I run the macro, the box opens, and prompts the user to answer a question by clicking yes or no. When they click the button, a task is performed. I can not figure out how to automatically close the dialog box, once the user has clicked the 'Yes' or 'No' buttons though. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Custom Dialog Box Macro for Excel
glad to help. thanks for the feed back
Regards FSt1 "floyd,p" wrote: That seemed to work. Thank You. "FSt1" wrote: hi add this to the end of your button code possible to both yes and no buttons. unload me Regards FSt1 "floyd,p" wrote: I have created a custom dialog box in VB, to be used as a macro in Excel. So far, when I run the macro, the box opens, and prompts the user to answer a question by clicking yes or no. When they click the button, a task is performed. I can not figure out how to automatically close the dialog box, once the user has clicked the 'Yes' or 'No' buttons though. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use the custom filter dialog in a macro | Excel Worksheet Functions | |||
| Display a Custom Dialog Box | Excel Discussion (Misc queries) | |||
| Help with custom save as dialog box. | Excel Discussion (Misc queries) | |||
| custom views dialog box | New Users to Excel | |||
| Excel custom function dialog | Excel Worksheet Functions | |||
Linear Mode
