leramone
New member
- Joined
- Aug 8, 2014
- Messages
- 13
- Reaction score
- 0
- Points
- 0
- Age
- 32
Hello everyone!
o/
As I'm diving into this new VBA world new issues and ideas are coming out of my mind. One of these are about casting checkbox values into another spreadsheet:
The Problem:
- I have a spreadsheet with several checkbox one-correlated with a checkbox in another spreadsheet (same workbook).
What I need:
- When the user check a box on 'sheet1' its correlated checkbox turn its value to checked too.
- If one checkbox changes its values, its correlated changes too, and vice-versa. It will work like a mirror, one always affecting the correlated, and vice-versa.
This attach may help to understand
http://goo.gl/Zcct7t
I don't know if VBA is the only way to solve it; hope not, hope there is a solution with formulas to check (or uncheck) both checkboxes.
My best regards!
o/
As I'm diving into this new VBA world new issues and ideas are coming out of my mind. One of these are about casting checkbox values into another spreadsheet:
The Problem:
- I have a spreadsheet with several checkbox one-correlated with a checkbox in another spreadsheet (same workbook).
What I need:
- When the user check a box on 'sheet1' its correlated checkbox turn its value to checked too.
- If one checkbox changes its values, its correlated changes too, and vice-versa. It will work like a mirror, one always affecting the correlated, and vice-versa.
This attach may help to understand
http://goo.gl/Zcct7t
I don't know if VBA is the only way to solve it; hope not, hope there is a solution with formulas to check (or uncheck) both checkboxes.
My best regards!