Emptying textboxes in a VBA form using a for next loop
Can I clear multiple textboxes in a loop please. I have tried the code below but it has the following error.
"Method or data member not found (Error 461)"
------------------------------------------------------------------------------------------------
Thanks
John
Dim a For a = 1 To 5 If UserForm1.Textbox(a).Text = "DATE" _ Then UserForm1.Textbox(a).Text = vbNullString Next UserForm1.PrintForm ' Print form
Try this then... Dim
Try this then
Vishesh,
This works great, thanks very much for your help and such a quick responce. Have a good night.
Kind regards
John
Emptying Textboxes
Emptying textboxes
Vishesh,
Thanks for such a quick reply unfortunately it empty’s all of the textboxes and not just the first five. Any other ideas?
Regards
John