Can't 'tick' box on fom with Sendkeys {SPACEBAR}
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?
|