Thread: set/get value of checkbox (controltoolbox)
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jesper F Jesper F is offline
external usenet poster
  
Posts: 2
Default set/get value of checkbox (controltoolbox)
Trying to get/set value from a checkbox.
I'm using the controltoolbox-checkbox.
I'm using:
Worksheets("refdata").Shapes(varname).ControlForma t.Value = 1

but getting a object does not support property error.
I need to refer to the checkbox with "varname" being af changable variable.

What is the correct syntax?
Thanks.
Reply With QuoteReply With Quote