Using a button without pressing Enter after entering data

[JaysonT]

This may seem a very basic question but I am in search of an answer.

I have a CommandButton which performs a number of tasks. Is it
possible to enter data into a cell and then press the button without
pressing Enter after entering the data? At this point to button does
not function without first pressing Enter.

Again sorry if this is really simple but I can't seem to find an
answer.

Thanks,
Jayson

 

[Trevor Shuttleworth]

Jayson

I don't think so. If you are entering data into a cell, you are editing the
cell and, until you've finished that task, Excel won't let you press your
button.

Regards

Trevor

This may seem a very basic question but I am in search of an answer.

I have a CommandButton which performs a number of tasks. Is it
possible to enter data into a cell and then press the button without
pressing Enter after entering the data? At this point to button does
not function without first pressing Enter.

Again sorry if this is really simple but I can't seem to find an
answer.

Thanks,
Jayson


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to

creating financial statements

 

[Don Guillett]

No and why ?

--
Don Guillett
SalesAid Software
(e-mail address removed)

This may seem a very basic question but I am in search of an answer.

I have a CommandButton which performs a number of tasks. Is it
possible to enter data into a cell and then press the button without
pressing Enter after entering the data? At this point to button does
not function without first pressing Enter.

Again sorry if this is really simple but I can't seem to find an
answer.

Thanks,
Jayson


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to

creating financial statements