Autostart Macro
Thank you Dave .
"Dave Peterson" wrote:
You can't change the font properties in a plain old msgbox. But you could
design your own userform and do as much customization as you want:
Option Explicit
Sub Auto_Open()
Msgbox "Only enter data in cells" & vblf & "that are color coded Tan!"
'or
Msgbox "Only enter data in cells" & vbnewline & "that are color coded Tan!"
End Sub
In the windows world, vblf (linefeed) is sufficient.
If you have to support both Wintel and Mac's, you may want to use vbnewline.
That constant is smart enough to know what to use on each.
Narasimha wrote:
Hi Dave ,
could you please help me how to enter text in two lines of message box ?
and how to change font properties colour etc...
"Dave Peterson" wrote:
This goes in a General module--not behind a worksheet, not behind ThisWorkbook.
Option Explicit
Sub Auto_Open()
Msgbox "Only enter data in cells that are color coded Tan!"
End Sub
McCloudK wrote:
I would like a simple text box or message to appear when a spreadsheet is
first opened that will require the user to push OK.
What I actually want is a box to pop up as sson as the spreadsheet is opened
that says "Only enter data in cells that are color coded Tan!" I would like
the message to stay on the screen until the uses clicks an OK button.
How would I accomplish this?
Thanks,
Ken
--
Dave Peterson
--
Dave Peterson
|