# Silly Visual Basic question

**URL:** <https://boards.straightdope.com/t/silly-visual-basic-question/138888>\
**Category:** Factual Questions\
**Created:** [November 26, 2002, 2:10pm UTC](https://boards.straightdope.com/t/silly-visual-basic-question/138888 "2002-11-26T14:10:28Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![DrLiver](https://avatars.discourse-cdn.com/v4/letter/d/90ced4/32.png) [@DrLiver](https://boards.straightdope.com/u/DrLiver)\
**Post date:** [November 26, 2002, 2:10pm UTC](https://boards.straightdope.com/t/silly-visual-basic-question/138888/1 "2002-11-26T14:10:28Z")

</div>

Ok, I have some basics about visual basic but I have a problem here:

I looked into the help thing for at least an hour and still can’t figure it out, so I’m turning to the dopers:

How do I do to have the checkboxes in an excell sheet to be automaticly activated when I open the worksheet? What I mean is that when I open the worksheet, that if I click on it, the check box either checks or unchecks and that I can’t move it around by drag and drop…

I tried checkbox1.activate  
but it doesn’t seem to do the trick…

so, anyone knows what I should do?

---

<div class="post-metadata">

**Author:** ![Dilbert](https://avatars.discourse-cdn.com/v4/letter/d/58f4c7/32.png) [@Dilbert](https://boards.straightdope.com/u/Dilbert)\
**Post date:** [November 26, 2002, 2:49pm UTC](https://boards.straightdope.com/t/silly-visual-basic-question/138888/2 "2002-11-26T14:49:52Z")

</div>

checkbox1.value = 1 (i could open up a project and make sure, but I’m almost positive)