Starchaser
New Member
- Joined
- Mar 4, 2017
- Messages
- 10
Hi everybody,
I want to copy selected data out of a listbox to different other sheets based on a selection of multiple checkboxes
I've already created a similar situation, but then you could only select one sheet at a time (by using a combobox).
But this means that the user had to click the submit button for each sheet he wants to copy the data.
If the user could select all sheets in one time and click one time the "submit" it would be "userfriendly".
Following choices are possible
1. For each checkbox selected the data in the textboxes should be copied to the sheet which has the same name as the selected boxes.
So the user can select multiple boxes to copy the data to multiple sheets in one time
2. If checkbox B and C is selected, the data should be copied to both sheets and also be copied to sheet "BC"
3. If checkbox A and B and C is selected, the data should be copied to all three sheets and also be copied to sheet "ABC"
Many thanks for your advice
grtz
I want to copy selected data out of a listbox to different other sheets based on a selection of multiple checkboxes
I've already created a similar situation, but then you could only select one sheet at a time (by using a combobox).
But this means that the user had to click the submit button for each sheet he wants to copy the data.
If the user could select all sheets in one time and click one time the "submit" it would be "userfriendly".
Following choices are possible
1. For each checkbox selected the data in the textboxes should be copied to the sheet which has the same name as the selected boxes.
So the user can select multiple boxes to copy the data to multiple sheets in one time
2. If checkbox B and C is selected, the data should be copied to both sheets and also be copied to sheet "BC"
3. If checkbox A and B and C is selected, the data should be copied to all three sheets and also be copied to sheet "ABC"
Many thanks for your advice
grtz