Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display a text box at startup
In previous versions of Excel you used to be able to create a text box that
was displayed to users at start-up - I had thought that this was in validation but can no longer find it - can anyone help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display a text box at startup
On Feb 25, 7:22*am, Eno wrote:
In previous versions of Excel you used to be able to create a text box that was displayed to users at start-up - I had thought that this was in validation but can no longer find it - can anyone help. Was it a text box or an Input Box or MsgBox? Do you just want a message to display when the workbook is opened? This goes into the WorkBook Module Private Sub Workbook_Open() MsgBox "Good Day!" End Sub |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display a text box at startup
It was an advisory box, a little like the 'Read only recommended' that you
can have, it popped up before displaying the data in the file. There was no coding required just a simple input from the standard tool bar. "CurlyDave" wrote: On Feb 25, 7:22 am, Eno wrote: In previous versions of Excel you used to be able to create a text box that was displayed to users at start-up - I had thought that this was in validation but can no longer find it - can anyone help. Was it a text box or an Input Box or MsgBox? Do you just want a message to display when the workbook is opened? This goes into the WorkBook Module Private Sub Workbook_Open() MsgBox "Good Day!" End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When I wrap text, excel hides the text display | Excel Discussion (Misc queries) | |||
Text does not display in "Text boxs" and when wrapping text in a c | Excel Discussion (Misc queries) | |||
how do i count text and display it as text plus the # times it hap | New Users to Excel | |||
Find text within cell then display text to left | Excel Discussion (Misc queries) | |||
Combobox display on startup | New Users to Excel |