| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can program go back to userform to give user another go at it?
What about putting the msgbox code into a While loop and move the
Me.Hide to outside the loop, eg While sTribeNameUI = "" Or sCYUI = "" Or sServMonthUI = "" _ Or sCYUI = "" MsgBox "Please select a Tribe Name, a Service Month and" & Chr(10) & _ " a Calendar Year!", vbOKOnly With Me.cbTribeName .SelStart = 0 .SelLength = Len(.Text) .SetFocus End With Wend me.Hide You may want to give the user and option to cancel and exit Cheers, Andrew |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell formula that will give back the address of the cursor? | Excel Worksheet Functions | |||
| To give back ground colour for entire row on certain condition | Excel Discussion (Misc queries) | |||
| How to give back a value, based in another table? | Excel Discussion (Misc queries) | |||
| give back times of current month automatically | Excel Programming | |||
| Do you give memory back? | Excel Programming | |||
Threaded Mode
