Custom Dialog Box Macro for Excel

  • Thread starter Thread starter floyd,p
  • Start date Start date
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.
 
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

Assign Macro Dialog Box 6
Display a Custom Dialog Box 3
Excel 2007: Help creating a macro that will run Solver? 3
Dialog Box Buttons 1
Paste to Find dialog box using a macro 3
Answer YES to Dialog boxes in Excel macro 2
Office Excel 2003 Macro error with .xls files 1
dialog boxes 5

Back
Top