MS Excel 5.0 Dialog

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I am very new to message boards, my 1st post in fact, and am hoping that someone can help! I have inserted a "MS Excel 5.0 Dialog" into my workbook. Everything works great if i select that sheet and right click on it and click run. My problem is I can't find a way to get it to run from a macro. I have tried everything I can think of, and every help file I can find, any ideas out there?
 
Substitute the name of your dialog sheet if it's not Dialog1.

DialogSheets("Dialog1").Show

--
Jim Rech
Excel MVP
| Hi, I am very new to message boards, my 1st post in fact, and am hoping
that someone can help! I have inserted a "MS Excel 5.0 Dialog" into my
workbook. Everything works great if i select that sheet and right click on
it and click run. My problem is I can't find a way to get it to run from a
macro. I have tried everything I can think of, and every help file I can
find, any ideas out there?
 

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

User created Dialog Box 1
Trouble Installing Excel VBA Code Cleaner into Office 365 0
Dialog Box Buttons 1
convert Microsoft Excel 5.0/95 to ms excel 2003 6
LISTBOX 1
Macro to save excel XP spreadsheet to excel 97 spreadsheet format 1
how to use MS Excel 5.0 Dialog 1
Run-time error ‘13’ mismatch type 1

Back
Top