Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code for form
Hi,
I have copied this from a form I created earlier only I cant remember what each item refers to as I cleavely named them all the same thing!! Could someone look at this and let me know what they should be refering to then I should be able to modify the code for my new form. Thanks For Each CDuration In ws.Range("CDuration") With Me.CDuration .AddItem CDuration.Value .List(.ListCount - 1, 1) = CDuration.Offset(0, 1).Value End With Next CDuration |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code for form
Forget this post - I have started a new one with even more questions!
"Leanne" wrote: Hi, I have copied this from a form I created earlier only I cant remember what each item refers to as I cleavely named them all the same thing!! Could someone look at this and let me know what they should be refering to then I should be able to modify the code for my new form. Thanks For Each CDuration In ws.Range("CDuration") With Me.CDuration .AddItem CDuration.Value .List(.ListCount - 1, 1) = CDuration.Offset(0, 1).Value End With Next CDuration |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Form Code Required | New Users to Excel | |||
Bar code into a form | Excel Programming | |||
What is missing from this form code? | Excel Programming | |||
Can't fix VBA code of workbook - Form | Excel Programming | |||
VBA code to finish this form, Thanks | Excel Programming |