Hello,
I want to include combobox2and combobox3 to clear the rest of the textbox. How to specify that with the code below?
So far, it only clear textboxes.
Thanks.
![]()
Private Sub cmdClearEntry_Click() For Each ctl In Controls If TypeName(ctl) = "TextBox" Then ctl.Tag = ctl.Text ctl.Text = vbNullString End If Next a = UniqueArrayByDict([Agency].Value, 1) a = advArrayListSort(a) With ListBox1 .List = a .ListIndex = 0 End With 'TextBox1.BackColor = 16777215 End Sub
Bookmarks