you cannot click straight onto the command button

That is true for a Control Toolbox command button. But if you use a Forms
toolbar button it's not an issue. Hopefully you can switch.

--
Jim
"DMW" wrote in message
ps.com...
| Hi Jim
|
| Thanks for this - its a great workaround. However, it presents me with
| another problem. When you complete the text box, you cannot click
| straight onto the command button - you have to click a cell to leave
| the text box first and then click the command button. Is there a way
| to eliminate this additional step as I want to make the use of this
| form as simple as possible? Thanks you so much for your help so far.
|
| Kind regards.
|
| Donna
|
|
| Jim Rech wrote:
| Can anyone suggest how I can change my code to instruct an afterupdate
or
| lostfocus event
|
| The only event a text box on a sheet has is the click event. I'd
suggest a
| different approach if you want to use a text box on a sheet - remove the
| macro from the text box and instead assign it to a button placed next to
the
| text box. Label the button something like "Commit" or "Click me when
text
| is complete".
|
| --
| Jim
|