Yami,

Bit short on info, but a control checkbox can be set with

ActiveSheet.CheckBox1.Value = True

or unset by setting to False.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"yami-s " wrote in message
...
Hi,
i have a form where the user fills in information, that by clicking the
submit button the form's information is pulled to the spreadsheet.
In one of the columns, I would like to create a checkbox that based on
the information in the form it can be checked or not.
I can I do it???
Thanks in advance
Yami


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