Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run Time Error 424 Combo Box User Form
Hey all my BRILLIANT friends,
Can you help? I am getting a run time error Private Sub UserForm_Initialize() Dim cVend As Range Dim cRan As Range Dim cProd As Range For Each cVend In wksLookupLists.Range("VendorList") With Me.cboVend .AddItem cVend.Value .List(.ListCount - 1, 1) = cVend.Offset(0, 1).Value End With Next cVend For Each cRan In wksLookupLists.Range("RanchIDList") With Me.cboRan .AddItem cRan.Value .List(.ListCount - 1, 1) = cRan.Offset(0, 1).Value End With Next cRan For Each cProd In wksLookupLists.Range("ProduceIDList") With Me.cboProd .AddItem cProd.Value .List(.ListCount - 1, 1) = cProd.Offset(0, 1).Value End With Next cProd End Sub -- Though daily learning, I LOVE EXCEL! Jennifer |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run Time Error 424 Combo Box User Form
on what line does the error occur. Your code worked fine for me. Step through
your code and see where it breaks. In the immediate window ?err.description I did this with a new workbook 1) chaged a sheetname to wksLookupLists 3) added three named ranges matching your names in the code 4) added a userform with three combos, same names as per your code 5) pasted your code into the code page of the userform I ran first time, no issues. If your range names or wks name was wrong, you'd get a 1004 error. if combobox names were wrong you'd geta compile error. "Jennifer" wrote: Hey all my BRILLIANT friends, Can you help? I am getting a run time error Private Sub UserForm_Initialize() Dim cVend As Range Dim cRan As Range Dim cProd As Range For Each cVend In wksLookupLists.Range("VendorList") With Me.cboVend .AddItem cVend.Value .List(.ListCount - 1, 1) = cVend.Offset(0, 1).Value End With Next cVend For Each cRan In wksLookupLists.Range("RanchIDList") With Me.cboRan .AddItem cRan.Value .List(.ListCount - 1, 1) = cRan.Offset(0, 1).Value End With Next cRan For Each cProd In wksLookupLists.Range("ProduceIDList") With Me.cboProd .AddItem cProd.Value .List(.ListCount - 1, 1) = cProd.Offset(0, 1).Value End With Next cProd End Sub -- Though daily learning, I LOVE EXCEL! Jennifer |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run Time Error 424 Combo Box User Form
Hey Patrick,
It is not hightling the area that has a problem it just says "Run Time Error 424" Object required I have to let you know this is a first time for me writing something like this, so I'm pretty stuck. How can I tell were the error occurs. Have double checked all names and worksheet names. I will double check again. Thank you for your time. Jennifer "Patrick Molloy" wrote: on what line does the error occur. Your code worked fine for me. Step through your code and see where it breaks. In the immediate window ?err.description I did this with a new workbook 1) chaged a sheetname to wksLookupLists 3) added three named ranges matching your names in the code 4) added a userform with three combos, same names as per your code 5) pasted your code into the code page of the userform I ran first time, no issues. If your range names or wks name was wrong, you'd get a 1004 error. if combobox names were wrong you'd geta compile error. "Jennifer" wrote: Hey all my BRILLIANT friends, Can you help? I am getting a run time error Private Sub UserForm_Initialize() Dim cVend As Range Dim cRan As Range Dim cProd As Range For Each cVend In wksLookupLists.Range("VendorList") With Me.cboVend .AddItem cVend.Value .List(.ListCount - 1, 1) = cVend.Offset(0, 1).Value End With Next cVend For Each cRan In wksLookupLists.Range("RanchIDList") With Me.cboRan .AddItem cRan.Value .List(.ListCount - 1, 1) = cRan.Offset(0, 1).Value End With Next cRan For Each cProd In wksLookupLists.Range("ProduceIDList") With Me.cboProd .AddItem cProd.Value .List(.ListCount - 1, 1) = cProd.Offset(0, 1).Value End With Next cProd End Sub -- Though daily learning, I LOVE EXCEL! Jennifer |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run Time Error 424 Combo Box User Form
go into the IDE and step through the code -- pressing F8 steps it.
You'll get an error on one line ... we need to identify it. "Jennifer" wrote in message ... Hey Patrick, It is not hightling the area that has a problem it just says "Run Time Error 424" Object required I have to let you know this is a first time for me writing something like this, so I'm pretty stuck. How can I tell were the error occurs. Have double checked all names and worksheet names. I will double check again. Thank you for your time. Jennifer "Patrick Molloy" wrote: on what line does the error occur. Your code worked fine for me. Step through your code and see where it breaks. In the immediate window ?err.description I did this with a new workbook 1) chaged a sheetname to wksLookupLists 3) added three named ranges matching your names in the code 4) added a userform with three combos, same names as per your code 5) pasted your code into the code page of the userform I ran first time, no issues. If your range names or wks name was wrong, you'd get a 1004 error. if combobox names were wrong you'd geta compile error. "Jennifer" wrote: Hey all my BRILLIANT friends, Can you help? I am getting a run time error Private Sub UserForm_Initialize() Dim cVend As Range Dim cRan As Range Dim cProd As Range For Each cVend In wksLookupLists.Range("VendorList") With Me.cboVend .AddItem cVend.Value .List(.ListCount - 1, 1) = cVend.Offset(0, 1).Value End With Next cVend For Each cRan In wksLookupLists.Range("RanchIDList") With Me.cboRan .AddItem cRan.Value .List(.ListCount - 1, 1) = cRan.Offset(0, 1).Value End With Next cRan For Each cProd In wksLookupLists.Range("ProduceIDList") With Me.cboProd .AddItem cProd.Value .List(.ListCount - 1, 1) = cProd.Offset(0, 1).Value End With Next cProd End Sub -- Though daily learning, I LOVE EXCEL! Jennifer |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding items to a combo box on a user form | Excel Discussion (Misc queries) | |||
Closing Excel user form generates error | Excel Discussion (Misc queries) | |||
User Form Error | Excel Discussion (Misc queries) | |||
Measuring Time in a user form syntax | Excel Programming |