checkbox insertion

J

jeremy

How can I insert a checkbox using thre forms toolbar and
have the check box fit into a cell as opposed
to 'floating' over it?
 
B

Bob Phillips

Jeremy,

You can't, a forms object is not part of a worksheet.

You might care to take a look at this alternative that I suggested
previously

http://tinyurl.com/sbur

--

HTH

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

Earl Kiosterud

Jeremy,

You can do this to a certain extent, if the checkbox fits entirely in the
cell. Ctrl-Click it, and use the handles to make it fit. The checkbox will
be copied when the cell is copied, etc. Also, right-click it, Format
Control - Properties. Here you'll probably want Move but don't size with
cells. Any cell contents will be under the checkbox, and thus obscured by
it, so you may have to mess with things to position the cell contents,
depending on what kind of stuff will be in the cell, and if it will vary.

YOu may find it simpler to put the checkbox in an adjacent cell, by itself.
Can't say more not knowing more specifics about your situation.
 

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

Similar Threads


Top