Excel VBA - Create Reset Button on UserForm

Ah Sing TV
Ah Sing TV
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 بـار بازدید شده
... بیشتر