| 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 | |||
Linear Mode
