Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
clicking cancle button still populates radio buttons, check box in
Hi all, I have designed an excel form with Three buttons Cancle, Clear and Submit The issue: When I input the data and click Cancle button, The form still populates the excel sheet with inputs in radio buttons and checkboxes but not the text box inputs. The code for my cancle button is Private Sub Cancel_Click() Unload Me End Sub Shouldnt it unload data from all the fields? Please HELP Thanks in Advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
clicking cancle button still populates radio buttons, check box in
Maybe this: UserForm1.Hide UserForm2.Show 'etc. Or this: Unload UserForm1 'etc. This will clear all TextBoxes on a Form: Private Sub cmdNew_Click() Dim C As MSForms.Control For Each C In Me.Controls If TypeOf C Is MSForms.TextBox Then C.Text = "" End If Next C End Sub HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "sam" wrote: Hi all, I have designed an excel form with Three buttons Cancle, Clear and Submit The issue: When I input the data and click Cancle button, The form still populates the excel sheet with inputs in radio buttons and checkboxes but not the text box inputs. The code for my cancle button is Private Sub Cancel_Click() Unload Me End Sub Shouldnt it unload data from all the fields? Please HELP Thanks in Advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reset button code for Radio Buttons | Excel Discussion (Misc queries) | |||
how do I add either a radio button or check box to an Excel doc? | Excel Discussion (Misc queries) | |||
Radio buttons, check boxes in Excel 2007 | Excel Discussion (Misc queries) | |||
Can you create a check box or radio button in Excel? | Excel Discussion (Misc queries) | |||
VBA: Disable Frame and Radio Buttons based on Another Radio Button Being True | Excel Worksheet Functions |