Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello helpless in iowa,
I would rather get rid of the message box and use instead a label to get the attention of the user for example, and I presume that you're using a Userform: Label2.Visible = True 'alerts the user to enter a numeric value txtphone.SetFocus txtphone.SelStart = 0 txtphone.SelLength = 1000 But in the UserForm_Initialize() you have to initialize the Label2.Visible as False, otherwise it appear when the Userform appears for the first time, which you won't like. Swisse |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
website prevents excel import web query | Excel Discussion (Misc queries) | |||
Simplifying a formula that prevents negative numbers | Excel Discussion (Misc queries) | |||
Excel prevents XP Pro laptop going on standby | Excel Discussion (Misc queries) | |||
what exactly prevents INDIRECT from accessing closed worksheets? | Excel Worksheet Functions | |||
MSG BOX PREVENTS setfocus HELP | Excel Programming |