Astroman
asked on
Use of dialogs in Excel
I want a dialog box with a combo box enumerating all worksheets in a workbook in Excel97. I want to call this dialog from a macro and get the result so I can then reference the correct worksheet.
I have found out how to draw dialogs, but I don't understand at all about how to actually use a dialog!
I am looking for a solution, but if people can point me to a good tutorial towards doing stuff like this, I would be grateful.
Leon
I have found out how to draw dialogs, but I don't understand at all about how to actually use a dialog!
I am looking for a solution, but if people can point me to a good tutorial towards doing stuff like this, I would be grateful.
Leon
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You are welcome, Leon! I'm glad that I could help you.
/Ture
/Ture
ASKER
It's funny, but I was getting pretty close, but I have nothing really to work from except the MSDN site, which doesn't seem much good for a beginner.
I thought there must have been an easier way to deal with dialogs other than writing loads of event handlers and stuff - thanks for showing me how.
Leon (aka Astroman!)