Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sendkey help needed | Excel Discussion (Misc queries) | |||
SENDKEY method | Excel Programming | |||
sendkey problem | Excel Programming | |||
SendKey Question | Excel Programming | |||
using sendkey to enter vbe password in Excel 2000 | Excel Programming |