Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create a dialog box
I have a few tricky workbooks made up for my staff.
The most elegant solution would be to have a dialog box open up everytime the workbook opens. The dialog box would give a few pointers to how to use the workbook and then they would click OK before using it. Is this possible or a pipe dream? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create a dialog box
Private Sub Workbook_Open() Msgbox "your message here" End Sub 'This is workbook event code. 'To input this code, right click on the Excel icon on the worksheet '(or next to the File menu if you maximise your workbooks), 'select View Code from the menu, and paste the code -- HTH RP (remove nothere from the email address if mailing direct) "Raza" wrote in message ... I have a few tricky workbooks made up for my staff. The most elegant solution would be to have a dialog box open up everytime the workbook opens. The dialog box would give a few pointers to how to use the workbook and then they would click OK before using it. Is this possible or a pipe dream? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create a dialog box
Bob-
Thanks for you help! One last question: How do I make 2 lines of text instead of 1 long line of text? Thanks! -Raza "Bob Phillips" wrote: Private Sub Workbook_Open() Msgbox "your message here" End Sub 'This is workbook event code. 'To input this code, right click on the Excel icon on the worksheet '(or next to the File menu if you maximise your workbooks), 'select View Code from the menu, and paste the code -- HTH RP (remove nothere from the email address if mailing direct) "Raza" wrote in message ... I have a few tricky workbooks made up for my staff. The most elegant solution would be to have a dialog box open up everytime the workbook opens. The dialog box would give a few pointers to how to use the workbook and then they would click OK before using it. Is this possible or a pipe dream? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create a dialog box
Msgbox "This is the first line " & vbNewLine & _
"and this is the second" -- HTH RP (remove nothere from the email address if mailing direct) "Raza" wrote in message ... Bob- Thanks for you help! One last question: How do I make 2 lines of text instead of 1 long line of text? Thanks! -Raza "Bob Phillips" wrote: Private Sub Workbook_Open() Msgbox "your message here" End Sub 'This is workbook event code. 'To input this code, right click on the Excel icon on the worksheet '(or next to the File menu if you maximise your workbooks), 'select View Code from the menu, and paste the code -- HTH RP (remove nothere from the email address if mailing direct) "Raza" wrote in message ... I have a few tricky workbooks made up for my staff. The most elegant solution would be to have a dialog box open up everytime the workbook opens. The dialog box would give a few pointers to how to use the workbook and then they would click OK before using it. Is this possible or a pipe dream? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i create a dialog box to appear on opening an excel wkbook | Excel Discussion (Misc queries) | |||
excel and VB Open Dialog box | Excel Discussion (Misc queries) | |||
Create Startup Dialog | Excel Discussion (Misc queries) | |||
Can't create dynamic charts | Charts and Charting in Excel | |||
Template in Excel | New Users to Excel |