View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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?