1 Attachment(s)
help with vba code in userform
hi, I am new to vba macro in word, I have followed guides and tutorials and I can t seem to get it to work. I just need 4 fields in the userform fill and entered when I click on the 'command button' . Please help as I have no clue why it has errors (it just highlight userform vba editor) and not sure how I can accomplish this. Please see attachments and if possible saved me from this endless journey. Thanks in advanced.
Userform Intialize selecting listbox to textbox
hi,
I have 10 listboxes in my userform and I can double click each listbox lines and populate information from there to 10 textboxes.
Im wondering if I can in Userform Intialize, once the userform opens that the inifromation in listboxes be populated automatically to the textboxes.
I have a code below but doesn't do anything really just selects the first list but no double click
lstLookup.Value = Selection
For i = 1 To lstLookup.ListCount - 1
lstLookup.Selected(i) = True
Next I
End Sub
Thanks
Steve