Thread: Clear all textboxes on a form ?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
SpookiePower SpookiePower is offline
external usenet poster
  
Posts: 30
Default Clear all textboxes on a form ?
No problem anymore.

I did it this way.

Private Sub cmdClearFormTextBox_Click()
For Each ctl In Me.Controls
If TypeName(ctl) = "TextBox" Then
ctl.Text = ""
End If
Next ctl
End Sub

Reply With QuoteReply With Quote