PC Review


Reply
Thread Tools Rate Thread

Check box format

 
 
=?Utf-8?B?QW50aG9ueUo=?=
Guest
Posts: n/a
 
      11th Oct 2006
This may be extremely simple, but I'll be darned if I can't figure it out.
Is there a way to set check boxes so that they are automatically centered in
the middle of a cell? I can get them to stay the same distance from the top
of the cell (FormatControls->properties->move but dont size with cell) but
then they are hidden if the row gets smaller, and get off center if the row
changes size at all. I don't like the move and size with cell option,
because that just contorts the box if there's a big change in row height.
The height of the rows will be changing a lot as information is changed, and
as the rows change, it makes sort of a mess of the check boxes.

Help would be appreciated.. Thanks.
--
AnthonyJ
 
Reply With Quote
 
 
 
 
=?Utf-8?B?QW50aG9ueUo=?=
Guest
Posts: n/a
 
      12th Oct 2006
Never mind. I looked thru all the old questions about check boxes and I
found an adequate solution - use the check boxes from the forms toolbar and
snap to grid. Not exactly what I was dreaming about, but good enough and I
don't have to mess with any code. Thanks everyone.
--
AnthonyJ


"AnthonyJ" wrote:

> This may be extremely simple, but I'll be darned if I can't figure it out.
> Is there a way to set check boxes so that they are automatically centered in
> the middle of a cell? I can get them to stay the same distance from the top
> of the cell (FormatControls->properties->move but dont size with cell) but
> then they are hidden if the row gets smaller, and get off center if the row
> changes size at all. I don't like the move and size with cell option,
> because that just contorts the box if there's a big change in row height.
> The height of the rows will be changing a lot as information is changed, and
> as the rows change, it makes sort of a mess of the check boxes.
>
> Help would be appreciated.. Thanks.
> --
> AnthonyJ

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
check format Rolf G Microsoft Excel Programming 5 8th Oct 2008 10:49 AM
Check if Conditional Format is True or False / Check cell Color =?Utf-8?B?S2V2aW4gTWNDYXJ0bmV5?= Microsoft Excel Worksheet Functions 5 29th Jun 2007 11:12 AM
Check Format =?Utf-8?B?U3R1ZGVudA==?= Microsoft Excel Programming 3 26th Oct 2006 03:56 PM
Check Box Format! Kim-Anh Tran Microsoft Excel Programming 5 3rd May 2004 11:01 PM
Check Box Format =?Utf-8?B?VHJ1?= Microsoft Excel Misc 1 30th Apr 2004 06:21 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:44 PM.