View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
D Zandveld D Zandveld is offline
external usenet poster
 
Posts: 33
Default Using Checkbox Values

I'm having a bit of trouble using checkbox values.

When I create a checkbox (using the control toolbox), right click and select
view code, the code opens in the worksheet in which it is created as a
private sub.

I want to be able to use the True\False value of this checkbox in a module,
but because it is private I cannot pass the value across.

I'm usually OK at all this but i'm getting frustrated with using controls,
any help (even simple help!) appreciated.

Thanks