View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
grinning_crow[_3_] grinning_crow[_3_] is offline
external usenet poster
 
Posts: 1
Default using Sub's with checkboxs

I'm not 100% sure, but you may want to try changing:

with box1

to:

with sheet1.box1

Also, consider whether the code you have is on a module or on the shee
or on the workbook, because this will make a difference whe
referencing objects. Also, be doubly sure you have actually changed th
Name of the checkbox to box1 and not the Caption.

I hope this is of some help

--
Message posted from http://www.ExcelForum.com