ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   MS Excel 5.0 Dialog (https://www.excelbanter.com/excel-programming/302311-ms-excel-5-0-dialog.html)

IamHaxer

MS Excel 5.0 Dialog
 
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?

Jim Rech

MS Excel 5.0 Dialog
 
Substitute the name of your dialog sheet if it's not Dialog1.

DialogSheets("Dialog1").Show

--
Jim Rech
Excel MVP
"IamHaxer" wrote in message
...
| 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?




All times are GMT +1. The time now is 10:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com