VBA - Userform - Loop - if Label have text

Question

Hi all How can I make a statement if label have text And TextBox have no text in a loop? I can't find anything about it I know with a textbox I can use the .TextLength but that don't work as .CaptionLength Hope you can help

For k = 2 To 41
   If Me.Controls("Label" & k).CaptionLength < 0 And Me.Controls("TextBox" & 
   k).TextLength = 0 Then
   MsgBox "You have a name without Hdc"

   Exit Sub
 End If

UPDATED With working Code

Dim k As Long
For k = 1 To 40
    If Len(Me.Controls("Label" & k).Caption) > 0 And Me.Controls("TextBox" & 
k).Text = vbNullString Then
    MsgBox "You have a name without Hdc"
    Exit Sub
    End If
Next

FunThomas · Accepted Answer · 2017-10-13 15:32:51Z

1

Try

If len(Me.Controls("Label" & k).caption) > 0 And ...

The len function returns the length of a string and the caption-property gives the text (caption) of a label

answered Oct 13, 2017 at 15:32

FunThomas

31.3k4 gold badges24 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

L.Frederiksen Over a year ago

Hmm I think its on the right track but it is bring up the msgbox even though there is no empty TextBox is it because I use the textbox wrong I tried using = and <> for the textbox also without closing with () If Len(Me.Controls("Label" & k).Caption) > 0 And (Me.Controls("TextBox" & k).TextLength <> 0) Then

L.Frederiksen Over a year ago

let me try with using len on textbox too

FunThomas Over a year ago

For the textbox, you can use the property text (not caption), but TextLength should work also. But if you want to check if the textbox is empty, you have to check for TextLength = 0

L.Frederiksen Over a year ago

Now its working EPIC thanks so much for your help much appreciated !

Collectives™ on Stack Overflow

VBA - Userform - Loop - if Label have text

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related