Excel VBA - Create Reset Button on UserForm
22 هزار بار بازدید -
6 سال پیش
-
A better approach 👉
A better approach 👉 • Create reset button on UserForm
How to create a reset button on UserForm? Reset all objects (TextBox, ComboBox, OptionButton and CheckBox) with just ONE click.
-----------------------------------------------------------------------------------------------------------
Code:
For i = 1 To 3
Me.Controls("TextBox" & i).Value = ""
Next i
Me.ComboBox1.Clear
Me.ComboBox1.Value = ""
For i = 1 To 2
Me.Controls("OptionButton" & i).Value = False
Me.Controls("CheckBox" & i).Value = False
Next i
-----------------------------------------------------------------------------------------------------------
*Remarks:
1. When OptionButton and CheckBox are "checked" their values are "True"
2. When OptionButton and CheckBox are "unchecked" their values are "False
6 سال پیش
در تاریخ 1397/04/09 منتشر شده
است.
22,095
بـار بازدید شده