Gixxer Lad
New Member
- Joined
- Dec 21, 2004
- Messages
- 21
- Office Version
- 365
- Platform
- Windows
Good evening all,
I would like a little assistance if possible, I have a userform with a list of names (labels) and a checkbox for each one, what I am after is to textjoin all the selected names separated by a comma.
For example, with the scenario below I would like to have the text "Bill, George, Luke" in cell A1 when the userform is exited.
I have been trying with the likes of:
dim str as string
str = worksheetfunction.textjoin ?? IF ????????????
and then transferring str to cell A1
But I am having no luck so must be doing something wrong.
As always, any help is greatly appreciated.
Kind regards
I would like a little assistance if possible, I have a userform with a list of names (labels) and a checkbox for each one, what I am after is to textjoin all the selected names separated by a comma.
For example, with the scenario below I would like to have the text "Bill, George, Luke" in cell A1 when the userform is exited.
I have been trying with the likes of:
dim str as string
str = worksheetfunction.textjoin ?? IF ????????????
and then transferring str to cell A1
But I am having no luck so must be doing something wrong.
As always, any help is greatly appreciated.
Kind regards