check textboxes for input

[peioz]

Hello,

Is there a way to easily check if all (a lot)textboxes in my userform are filled in by the user ?

Thnx in advance.

 

[Richie(UK)]

Hi peioz,

Two possibilities occur to me:

1. A simple loop through all of the textboxes checking for entries, or

2. Forcing users to enter data in one box at a time. Eg, the user can't move to box2 until there is data entered in box1.

Are either of these approaches practical?

 

[peioz]

On 2002-08-23 03:54, Richie(UK) wrote:
Hi peioz,

Two possibilities occur to me:

1. A simple loop through all of the textboxes checking for entries, or

2. Forcing users to enter data in one box at a time. Eg, the user can't move to box2 until there is data entered in box1.

Are either of these approaches practical?

I quess the first option would be practical, but what I want to prevent is typing each name of the textbox seperately...

 

[Richie(UK)]

Hi,

Could you modify something along these lines?

<pre>
Private Sub UserForm_Initialize()
Dim MyControl As Control
Dim i As Integer

For Each MyControl In Controls
If (MyControl.Name Like "TextBox*") Then i = i + 1
Next

MsgBox "There are " & i & " TextBoxes on the UserForm."

End Sub

</pre>

HTH

 

[peioz]

On 2002-08-23 04:40, Richie(UK) wrote:
Hi,

Could you modify something along these lines?

<pre>
Private Sub UserForm_Initialize()
Dim MyControl As Control
Dim i As Integer

For Each MyControl In Controls
If (MyControl.Name Like "TextBox*") Then i = i + 1
Next

MsgBox "There are " & i & " TextBoxes on the UserForm."

End Sub

</pre>

HTH

I'll try it out ! thnx !