| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check all textboxes
Great. Works perfectly thank you
On May 7, 3:15 pm, merjet wrote: On May 7, 1:35 pm, stewart wrote: merjet, this does work but is there a way to specify a certain page in a multipage control. Also how do I stop it once it has found an empty textbox. You can specify the page, stop the Sub and set the focus on the empty TextBox as follows. Dim ctrl As Control For Each ctrl In Me.Controls If TypeOf ctrl Is MSForms.TextBox And ctrl.Parent.Name = "Page1" Then If ctrl.Value = "" Then MsgBox "fill it" ctrl.SetFocus Exit Sub Else MsgBox "its filled" End If End If Next ctrl Hth, Merjet |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If Then's for 12 textboxes to check if they are empty. | Excel Discussion (Misc queries) | |||
| Textboxes | Excel Programming | |||
| check is input textboxes is numeric on userform | Excel Programming | |||
| sum of textboxes | Excel Programming | |||
| textboxes | Excel Programming | |||
Threaded Mode
