Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Clear Comboboxes & Textboxes
Hi,
I have a userform containing various VBA controls such as comboboxes, listboxes and check boxes. I want to provide the option for a user to clear the form. I have tried the below code but get an error message stating 'Compile error - Sub or Function not defined' Please can anyone tell me where I am going wrong with this? Command Button Code - Private Sub cmdbuttonClear_Click() Call frmDataEntry_Initialize End Sub Thanks for any help, Mickey |
#2
|
|||
|
|||
Try using the Command Button with the code like
Private Sub CommandButton1_Click() ComboBox1 = "" TextBox1 = "" End Sub etc Regards, "MBlake" wrote in message ... Hi, I have a userform containing various VBA controls such as comboboxes, listboxes and check boxes. I want to provide the option for a user to clear the form. I have tried the below code but get an error message stating 'Compile error - Sub or Function not defined' Please can anyone tell me where I am going wrong with this? Command Button Code - Private Sub cmdbuttonClear_Click() Call frmDataEntry_Initialize End Sub Thanks for any help, Mickey |
#3
|
|||
|
|||
You probably want
Call Userform_Initialize rather than Call frmDataEntry_Initialize -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "MBlake" wrote in message ... Hi, I have a userform containing various VBA controls such as comboboxes, listboxes and check boxes. I want to provide the option for a user to clear the form. I have tried the below code but get an error message stating 'Compile error - Sub or Function not defined' Please can anyone tell me where I am going wrong with this? Command Button Code - Private Sub cmdbuttonClear_Click() Call frmDataEntry_Initialize End Sub Thanks for any help, Mickey |
#4
|
|||
|
|||
Cheers Guys,
Some days I feel likeI am getting there and then other days I feel miles away. It is all good fun though :-) Mickey |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel: Clear all cell entries EXCEPT formulas? | Excel Discussion (Misc queries) | |||
need to clear data references in pivot table report | Charts and Charting in Excel | |||
Button to clear all entries? | Excel Worksheet Functions | |||
offset and clear | Excel Discussion (Misc queries) | |||
how to clear the recently used files and still keep settings to k. | Excel Discussion (Misc queries) |