ManUBlueJay
Active Member
- Joined
- Aug 30, 2012
- Messages
- 320
- Office Version
- 365
- Platform
- Windows
I have a tabke I use as an entry form with 6 cells
I am trying to hide an update button till all 6 cells in the form have a value. I am using Worksheet_Change. to evaluate it everytime there is a change in the form
I have a cell that returns a true if the form is complete, however the Worksheet_Change. is so quick it evaluates that cell prior to when I made the change.
I am also open to do the evaluating in VBA.
I am trying to hide an update button till all 6 cells in the form have a value. I am using Worksheet_Change. to evaluate it everytime there is a change in the form
I have a cell that returns a true if the form is complete, however the Worksheet_Change. is so quick it evaluates that cell prior to when I made the change.
I am also open to do the evaluating in VBA.