Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automated Popups
Good Day,
I would like a popup screen to come up automatically when a spreadsheet is open. This popup will provide directions to the users of the spreadsheet. (I have a second sheet that provides directions but, I would like to emphasize a couple points. I hope this is a feature within Excel but, I wouldnt be surprised if I need to use VBA code to make it happen. Any suggestions, would be greatly appreciated. Thanks, Brad |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automated Popups
It is the MsgBox function within VBA procedures that will help you.
Here is an example of a MSgBox that might work for you. Take this routine, insert it into into a module in your worksheet. Then close and open the sheet again. Then change ths message as you need to Private Sub Workbook_Open() Dim Msg, Style, Title, Help, Ctxt, Response, MyString Msg = "This is a reminder only - Don't forget to change the status to it's appropriate level" Style = vbOKOnly Title = "Data Prompt" Response = MsgBox(Msg, Style, Title) If Response = vbOK Then Exit Sub Else Cancel = True End If End Sub -- thanks ah "Brad.R.Sutton" wrote: Good Day, I would like a popup screen to come up automatically when a spreadsheet is open. This popup will provide directions to the users of the spreadsheet. (I have a second sheet that provides directions but, I would like to emphasize a couple points. I hope this is a feature within Excel but, I wouldnt be surprised if I need to use VBA code to make it happen. Any suggestions, would be greatly appreciated. Thanks, Brad |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automated task to present data in a graph form. | Charts and Charting in Excel | |||
Automated task to present data in a graph form. | Charts and Charting in Excel | |||
How do I set up an automated numbering system For my "Invoice Num | Excel Worksheet Functions | |||
Division by zero in automated subtotals | Excel Discussion (Misc queries) | |||
3 questions about automated c++ com add-in worksheet functions | Excel Worksheet Functions |