How do you create a macro on a worksheet that opens a dialog box?

  • Thread starter Thread starter Mark
  • Start date Start date
It depends on the dialog box.

If you want to show an inbuilt excel dialog box then:

dlgAnswer = Application.Dialogs(xlDialogOpen).Show

will show the FileOpen dialog box. Search help for the other built in dialog
boxes to replace xlDialogOpen.

If you want to get simple information from the user you could use InputBox.

Otherwise you can design your own forms to show to the user by inserting a
UserForm in the Visual Basic Editor and using the MyFormName.show in your
macro.

Neal
 

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

How to create dialog box that will post to worksheet encoded data? 1
How to create a dialog box to encode information to worksheet? 2
Custom Dialog Box Macro for Excel 3
Multiple worksheet Copy Paste Macro 2
Display a Custom Dialog Box 3
How do I change a pop-up dialog box in an Excel cell? Not comment 1
Paste to Find dialog box using a macro 3
Spelling checker problem on a specific worksheet only 1

Back
Top