G
Guest
Good morning, all.
I'm sorry to say I'm now turning my attention to userforms (collective groan
from both hemispheres)
This one's quite easy, though (well, for SOMEone out there) Here's my code
to add some items to a listbox:
Private Sub UserForm_Initialize()
With lstEmployees
.AddItem "Dave"
.AddItem "Rob"
.AddItem "Greg"
.AddItem "Christina"
.AddItem "Mark"
End With
cmdAdd.Enabled = False
cmdRemove.Enabled = False
cmdRemoveAll.Enabled = False
End Sub
However, how to I popiulate the listbox with, say, A1:A6 (or a named range)
from (say) Shee t2?
Thanks in advance
Pete
I'm sorry to say I'm now turning my attention to userforms (collective groan
from both hemispheres)
This one's quite easy, though (well, for SOMEone out there) Here's my code
to add some items to a listbox:
Private Sub UserForm_Initialize()
With lstEmployees
.AddItem "Dave"
.AddItem "Rob"
.AddItem "Greg"
.AddItem "Christina"
.AddItem "Mark"
End With
cmdAdd.Enabled = False
cmdRemove.Enabled = False
cmdRemoveAll.Enabled = False
End Sub
However, how to I popiulate the listbox with, say, A1:A6 (or a named range)
from (say) Shee t2?
Thanks in advance
Pete