Thread: Programmically setting Excel checkboxs(Forms Shape object)
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Leith Ross[_689_] Leith Ross[_689_] is offline
external usenet poster
  
Posts: 1
Default Programmically setting Excel checkboxs(Forms Shape object)

Hello Alpah1,

To Set the CheckBox...
Worksheets("Sheet1").Shapes("Check Box 1").ControlFormat.Value = True

To Clear the CheckBox...
Worksheets("Sheet1").Shapes("Combo Box 1").ControlFormat.Value = False

Change the Worksheet name and checkbox name if they are different in
your code.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=564178

Reply With QuoteReply With Quote