Jak
Well-known Member
- Joined
- Apr 5, 2002
- Messages
- 833
Hi All
I want to load a VB Modeless User Form and have the user select a cell on the spreadsheet and populate it with a heading from the UserForm. This will continue until all seven headings have been selected.
"Forename"
"Initial"
"Surname"
"DOB"
"Ethnicity"
"Gender"
"Centre Candidate ID."
I need some help on how to do this. I have added a listbox to my UserForm and I need to populate it with the above list. The list must be hard coded into the userform rather than populating the list from a spreadsheet.
The idea is to force the user to add the seven titles to a header row on a spreadsheet.
Any examples would be great.
I want to load a VB Modeless User Form and have the user select a cell on the spreadsheet and populate it with a heading from the UserForm. This will continue until all seven headings have been selected.
"Forename"
"Initial"
"Surname"
"DOB"
"Ethnicity"
"Gender"
"Centre Candidate ID."
I need some help on how to do this. I have added a listbox to my UserForm and I need to populate it with the above list. The list must be hard coded into the userform rather than populating the list from a spreadsheet.
The idea is to force the user to add the seven titles to a header row on a spreadsheet.
Any examples would be great.