Dear expert,
Please find attached file with below details and requirement.
CURRENT FUNCTIONALITY:
1. Click on “Button2” on Excel sheet. “UserForm1” will open.
2. Click on “CommandButton1”, “UserForm2” will open.
3. Select multiple weekdays (any 2 or 3) Click on “CommandButton1”.
4. TextBox will be populated with the selected Values.
5. Again if you click the “CommandButton1”, “UserForm2” will open with fresh option of selection, if you continue the process it will over write the values of text box.
HELP NEEDED (REQUIREMENT)
1. If the textbox has values (in short if we populate the selection list for second time) the values available in the textbox should be selected in the list.
2. i.e. if textbox has value “Monday” and I popup the list, “Monday” should be already selected.
3. If then I select “Tuesday” (along with Monday selected) and submit. Textbox should have both the value. That means added values.
Immediate help will be appreciated.
Thanks
MG
Bookmarks