Is there are 'sendkey' statement to activate the spacebar?
 

I'm trying to automate the input of data on a large number of forms and have
come up against a problem with entering a spacebar command. I can't find
this among Visual Basic help and, as far as I can see, no other keyboard
command will tick thje box I need ticked.

Any way round this?

Is there are 'sendkey' statement to activate the spacebar?
 

SendKeys " "



--
Cheers
Nigel



"Zakynthos" wrote in message
...
I'm trying to automate the input of data on a large number of forms and
have
come up against a problem with entering a spacebar command. I can't find
this among Visual Basic help and, as far as I can see, no other keyboard
command will tick thje box I need ticked.

Any way round this?

Is there are 'sendkey' statement to activate the spacebar?
 

Nigel,

Thanks for that, I've tried it but it doesn't seem to work in the form I'm
using.

If I send two Sendkeys "{TAB}" commands (from 2 tabs above the checkbox I
want to select) I achieve the same thing, i.e. the label to the checkbox is
'selected' (dotted rectangle) but Sendkeys "" or Sendkeys "{Space}", Sendkeys
"{SPC}" or Sendkeys "{Spacebar}" won't put a tick in the box I need a tick in!

Any other possibilities?

Thanks

Tony

"Nigel" wrote:

SendKeys " "



--
Cheers
Nigel



"Zakynthos" wrote in message
...
I'm trying to automate the input of data on a large number of forms and
have
come up against a problem with entering a spacebar command. I can't find
this among Visual Basic help and, as far as I can see, no other keyboard
command will tick thje box I need ticked.

Any way round this?