C
Chas
Hi all. I cant seem to find info on how to create a dialog box. When a user clicks on a command button I would like to have a dialog box appear with instructions and an OK button
TI
TI
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
Frank Kabel
Hi
have a look at
msgbox
in the VBA help
like to have a dialog box appear with instructions and an
OK button.
have a look at
msgbox
in the VBA help
dialog box. When a user clicks on a command button I would-----Original Message-----
Hi all. I cant seem to find info on how to create a
like to have a dialog box appear with instructions and an
OK button.
T
Tom Ogilvy
You would use a Userform in Excel 97 or later. Here are some resources:
http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm
Lesson 11: Creating a Custom Form
Excerpted from Microsoft® Excel 97 Visual Basic® Step by Step.
http://support.microsoft.com/?id=168067
XL97: WE1163: "Visual Basic Examples for Controlling UserForms"
Microsoft(R) Visual Basic(R) for Applications Examples for Controlling
UserForms in Microsoft Excel 97
This Application Note is an introduction to manipulating UserForms in
Microsoft Excel 97. It includes examples and Microsoft Visual Basic for
Applications macros that show you how to take advantage of the capabilities
of UserForms and use each of the ActiveX controls that are available for
UserForms
--
Regards,
Tom Ogilvy
with instructions and an OK button.
http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm
Lesson 11: Creating a Custom Form
Excerpted from Microsoft® Excel 97 Visual Basic® Step by Step.
http://support.microsoft.com/?id=168067
XL97: WE1163: "Visual Basic Examples for Controlling UserForms"
Microsoft(R) Visual Basic(R) for Applications Examples for Controlling
UserForms in Microsoft Excel 97
This Application Note is an introduction to manipulating UserForms in
Microsoft Excel 97. It includes examples and Microsoft Visual Basic for
Applications macros that show you how to take advantage of the capabilities
of UserForms and use each of the ActiveX controls that are available for
UserForms
--
Regards,
Tom Ogilvy
user clicks on a command button I would like to have a dialog box appearChas said:Hi all. I cant seem to find info on how to create a dialog box. When a
with instructions and an OK button.
B
Bob Phillips
You can create one of 3 things
1. a Msgbox, a simple info box with specified buttons the user can click
2. an Inputbox, like Msgbox, but user inputs a response, and only OK Cancel
buttons
3. A userform where you can create whatever controls and labels you desire./
Which suits best?
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
with instructions and an OK button.
1. a Msgbox, a simple info box with specified buttons the user can click
2. an Inputbox, like Msgbox, but user inputs a response, and only OK Cancel
buttons
3. A userform where you can create whatever controls and labels you desire./
Which suits best?
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
user clicks on a command button I would like to have a dialog box appearChas said:Hi all. I cant seem to find info on how to create a dialog box. When a
with instructions and an OK button.