Using a button without pressing Enter after entering data

J

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
 
T

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


JaysonT said:
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
Click to expand...
creating financial statements
 
D

Don Guillett

No and why ?

--
Don Guillett
SalesAid Software
[email protected]
JaysonT said:
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
Click to expand...
creating financial statements
 
Top