Custom Dialog Box Macro for Excel

F

floyd,p

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.
 
F

FSt1

hi
add this to the end of your button code possible to both yes and no buttons.
unload me

Regards
FSt1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Task Information Dialog Box not making duration changes to task 0
Need Help with Macro Security 1
Save last item copied 0
Word macro that can call cells out of Excel for a find and replace 0
Macro Code for bringing up Save As dialog box and changing file Type 0
Shortcuts in OneDrive 0
Getting Radio Buttons to work, that are inserted via AutoText 0
Embedded Excel into Word with Tables 0

Top