Hi
I need a checkbox (actually a few but I will use the same code and change the name and cell reference) to do the following and I hope you can help!
- Checkbox in A1 is ON by default
- B1 is 100
- User can free change the value of B1 when checkbox is on
- When checkbox is OFF
- "100" (or whatever number entered by the user) gets stored
- B1 changes to a relatively large number "9999"
- B1 changes cell color to grey and is locked for edit
- When checkbox is ON again
- The value stored previous to checkbox turned OFF is restored back to B1
- B1 changes back to normal cell color (no fill or white)
- B1 is unlocked and user can edit the cell
Please help, thank you!
Bookmarks