View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kim-Anh Tran[_24_] Kim-Anh Tran[_24_] is offline
external usenet poster
 
Posts: 1
Default How to link a check box from form to a cell?

Hello everyone,
I have a check box placed by cell B5. I would like to give value 1 to
cell B10 every time this box is check and 0 when unchecked. But I have
problem linking this to a cell. I know that I can link to a cell using
check box from control tool box. But I don't now how to write code
using VB.
Thanks in advance fro any help!
Regards,
Kim-Anh


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