Here's the problem.
I'm designing a worksheet for very young children and what they need to do is type a number into a cell and then click a button to run the macro. However, in order to click this button they first must either press ENTER or TAB or click out of the cell. ie, it wont let them just type in a number and click the button cos nothing happens.
How do I make the button work when the kid hasn't ENTERED or TABBED or clicked somewhere else?