- Joined
- Aug 9, 2009
- Messages
- 11
- Reaction score
- 0
I am spoiled by some of the functionality in Access when I use Excel, and am also amazed at what people have figured out how to do in Excel.
What I would like to to in Excel:
When I leave the current cell,
1. evaluate the contents of the cell I am leaving (essentially determining if it is empty or not
2. If it is empty, do nothing
If it is not empty (or maybe if it has a number value in it)
3. Then uncheck a box (a check box form control)
In Access, I would enter code in on Leave property
It would essentially change the value in the text box that would be named or have some other unique method of identifying it.
In Excel, I do not know to make a macro fire upon leaving a cell
And I do not know how to refer to the properties of a specific check box control. that is, there will be many of them in the spreadsheet and I do not see how to name them. Clicking of properties for the check box gave no hint of it.
What I would like to to in Excel:
When I leave the current cell,
1. evaluate the contents of the cell I am leaving (essentially determining if it is empty or not
2. If it is empty, do nothing
If it is not empty (or maybe if it has a number value in it)
3. Then uncheck a box (a check box form control)
In Access, I would enter code in on Leave property
It would essentially change the value in the text box that would be named or have some other unique method of identifying it.
In Excel, I do not know to make a macro fire upon leaving a cell
And I do not know how to refer to the properties of a specific check box control. that is, there will be many of them in the spreadsheet and I do not see how to name them. Clicking of properties for the check box gave no hint of it.