Thread: Code for form
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Leanne Leanne is offline
external usenet poster
 
Posts: 87
Default 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