How to "install" a checkbox into a cell, then copy it to the entire column...???? (new user to exce

N

niteowl

Hi,

I am new to excel, and need to create a Yes/No Check box for a couple
of column for a form that will be used as a database for a small
school..

How do I "insert" the checkbox into the cell? I found one in the
"View/Toolbars", but can't seem to put it anywhere special, it just
sits on the page whereever I drag it to.. ???

I don't know anything about macros or VB, but willing to learn ....

Eventually I'd like to be able to key on a particular set of these
"checked" boxes to create a sublist from the master... possible?

thanks for any help.

niteowl
 
B

Biff

Hi!

Technically, you don't insert a checkbox into a cell. A
checkbox is an object and objects just "sit" on top of the
worksheet. So basically, the checkbox sits on top of the
cell. You can still enter data in a cell that appears
to "contain" a checkbox.

You should be able to drag and place it where ever you
want.

Biff
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top