I am trying to clear old entries in TextBoxes using this code
This fails with the & highlighted and a "Syntax error"![]()
With UserForm1 For a = 1 To 6 .TextBox & "a".Value="" Next a End With
Why is this wrong?
John
I am trying to clear old entries in TextBoxes using this code
This fails with the & highlighted and a "Syntax error"![]()
With UserForm1 For a = 1 To 6 .TextBox & "a".Value="" Next a End With
Why is this wrong?
John
"a" is the letter a
Try:
![]()
Dim a As Integer With UserForm1 For a = 1 To 6 .Controls("TextBox" & a).Value = "" Next a End With
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks