I think the application I'm using does support automation, as I'm able to use
Sendkey commands for most things like entering data, going to next page etc
etc.

So how do I get a tick in the box without using Sendkey "{SPACE}" etc which
plainly doesn't work?

"Tom Ogilvy" wrote:

No. Not unless the third party app supports automation or command line
arguments.

--
Regards,
Tom Ogilvy

"Zakynthos" wrote in message
...
I'm sorry, I did not explain myself very well!!!

I want to put a tick into a form into a third part (non Microsoft)
application. I know that the VB code you give will tick a checkbox in an
Excel workbook but, given that the Sendkeys "" or Sendkeys "{SPACE}"
command
has no effect in the window of the application's form I wish to tick a
box
in, is there an alternative code I could use that would work?

"Tom Ogilvy" wrote:

if a check box from the control toolbox toolbar
activesheet.Checkbox1.Value = True

or if a checkbox from the forms toolbar

activesheet.Checkboxes("Check Box 1").Value = xlOn

If you are using some built in dialog, then explain exactly what you are
trying to do.

--
Regards,
Tom Ogilvy


"Zakynthos" wrote in message
...
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 alternatives?