I
ivarsb
I want to create a UserForm which would work like this.
1. I turn UserModal to false in order to be able to click on cells
when the UserForm is showed.
2. When I check in Checkbox then all selected cells are changing style
or value depending which option I choose
3. Then I click on cells and they automatically without pressing any
button change style
Normally I would choose SelectionChange event from the workbook. But I
wanted to handle SelectionChange event from other workbook, which is
my personal workbook. How can I handle that without pasting code in
Worksheet page manually?
1. I turn UserModal to false in order to be able to click on cells
when the UserForm is showed.
2. When I check in Checkbox then all selected cells are changing style
or value depending which option I choose
3. Then I click on cells and they automatically without pressing any
button change style
Normally I would choose SelectionChange event from the workbook. But I
wanted to handle SelectionChange event from other workbook, which is
my personal workbook. How can I handle that without pasting code in
Worksheet page manually?