Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login




Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

How do you size a check box in Excel?Helpful Member!(2) 

JeanetteM (TechnicalUser) (OP)
21 Sep 04 9:25
I have added a check box in Excel 2000.  How do I size the check box.  I can change the size of the associated label but can not figure out how to change the size of the box itself.

Please help!  
Thx.
~JM

For all your virtual administrative needs visit
http://www3.sympatico.ca/lanceandjeanette

Helpful Member!(2)  cLFlaVA (Programmer)
21 Sep 04 9:44
Is it on a UserForm or on a Worksheet?

If it's on a UserForm, I suggest using the Zoom property of the form.  For example, you could make everything (except your Checkbox) 1/2 size, then zoom to 200.  This would make everything appear normal except the Checkbox, which is now twice as large.

*cLFlaVA
----------------------------
When will I be able to see what other members can see about myself?  It's been like, a freakin' month already!

jdemmi (MIS)
21 Sep 04 9:49
I have office XP and I found this in the Help File (not sure if it's the same in Office 2K). I searched for reszie checkbox.

MOVE OR RESIZE A CONTROL
Microsoft Excel has two different types of controls that you move and resize in different ways:
ActiveX controls, and controls from the Forms toolbar.

Determine which type of control you have: right-click the control you want to change.
If no shortcut menu appears or the shortcut menu contains the command Properties, the control is an ActiveX control.

If the shortcut menu contains the command Assign Macro, the control is a Forms toolbar control.

Based on the type of control you are working with, do one of the following:

MOVE OR RESIZE AN ACTIVEX CONTROL

Display the Control Toolbox: point to Toolbars on the View menu, and then click Control Toolbox.
Click Design Mode .
Do one or more of the following:
Move the control   Drag it to another location. To align it with cell gridlines, hold down ALT while you drag the control.

Resize the control   Drag one of the sizing handles:

To retain the proportions of the control, hold down SHIFT while you drag a corner sizing handle.

Set whether changes to the underlying cells affect the control   To change how the control is resized or moved when the cells underneath it are resized or moved, right-click the control, click Format Control, and then click the Properties tab.

When you finish modifying the control, click Exit Design Mode .

MOVE OR RESIZE A FORMS TOOLBAR CONTROL
Do one or more of the following:

1.Move the control. Drag it to another location. To align it with cell gridlines, hold down ALT while you drag the control.

2.Resize the control. Drag one of the sizing handles:

To retain the proportions of the control, hold down SHIFT while you drag a corner sizing handle.

Set whether changes to the underlying cells affect the control   To change how the control is resized or moved when the cells underneath it are resized or moved, right-click the control, click Format Control, click the Properties tab, and then click the option you want under Object positioning.

3. To remove the handles when you're finished modifying the control, click a cell on the worksheet.
cLFlaVA (Programmer)
21 Sep 04 9:55
Unfortunately that will only make the dimensions of the surrounding area larger, while keeping the actual box the same size.

*cLFlaVA
----------------------------
When will I be able to see what other members can see about myself?  It's been like, a freakin' month already!

JeanetteM (TechnicalUser) (OP)
21 Sep 04 9:59
Hi,

cLFlaVA's right.  It's just the little check box itself I need to resize.

I am in a worksheet and not a user form.  Any other suggestions?

Thanks,
~JM

For all your virtual administrative needs visit
http://www3.sympatico.ca/lanceandjeanette

Zathras (Programmer)
21 Sep 04 10:32
If you grok VBA you can use an IMAGE control (from the Control Toolbox) to display a square with a check alternating with an empty square by processing the Image_Click event.  But there is a bit of work involved to create the bitmaps and process the clicks.  

It may not be worth the trouble.  You never did say why you think you need to do this thing.  Can you provide some insight?

fumei (TechnicalUser)
21 Sep 04 14:22
Grok?  I have not heard that word used in a LONG time.

I agree.  Why do you need to resize the checkbox?  And besides, from the instructions posted, those changes are in design mode.  Are you talking about resizing at run-time?  Why?

Also, it was not answered (I think, but I can be dense at times), what kind of checkbox it is.  If it is an ActiveX control, programatically you can use:

With ActiveSheet.Shapes("nameOfcontrol")
   .Height = x
   .Width = y
End With

Or am I missing something?

Gerry

ETID (Programmer)
22 Sep 04 10:01
FYI...for those less hip (like myself)

GROK:

To grok (pronounced GRAHK) something is to understand something so well that it is fully absorbed into oneself. In Robert Heinlein's science-fiction novel of 1961, Stranger in a Strange Land, the word is Martian and literally means "to drink" but metaphorically means "to take it all in," to understand fully, or to "be at one with." Today, grok sometimes is used to include acceptance as well as comprehension - to "dig" or appreciate as well as to know.
As one character from Heinlein's novel says:

'Grok' means to understand so thoroughly that the observer becomes a part of the observed - to merge, blend, intermarry, lose identity in group experience. It means almost everything that we mean by religion, philosophy, and science - and it means as little to us (because we are from Earth) as color means to a blind man.
In common usage, "Do you grok?" seems close in meaning to "Do you get it?"



misscrf (TechnicalUser)
22 Sep 04 10:31
this may be a stupid response, but I think it is a font thing.  I think if you have it selected, it is like a symbol and you might be able to make the font bigger.

If not your sol! sorry!

misscrf

Management is doing things right, leadership is doing the right things

misscrf (TechnicalUser)
22 Sep 04 10:34
ok I found it.  Right click the check box, format control, and under size.... make the dimensions bigger!

I swear it works.  I just tested it.

:D

misscrf

Management is doing things right, leadership is doing the right things

cLFlaVA (Programmer)
22 Sep 04 10:42
Ummm, what?

*cLFlaVA
----------------------------
Breaking the habit...

cLFlaVA (Programmer)
22 Sep 04 10:45
I have found a way.

 - Place a Checkbox on your Worksheet.
 - Right Click, Format Control.
 - Properties Tab.
 - Select Move and Size with cells.
 - Make the cell that it hovers over larger (vert and horiz).

This will make the text look terrible too, however.  I suggest having no caption, then placing a label next to it.

Hope this helps.

*cLFlaVA
----------------------------
Breaking the habit...

SkipVought (Programmer)
22 Sep 04 10:47
???

Skip,

Be advised:  When transmitting sheet music...
If it ain't baroque, don't fax it!

fumei (TechnicalUser)
22 Sep 04 10:55
Since ETID used grok, I will use a phrase from the same source, and state "I am only an egg."

I thought this was a question on resizing the control programatically.

But I not have grokked it.

Gerry

cLFlaVA (Programmer)
22 Sep 04 10:56
Lol, what's the question Skip?

*cLFlaVA
----------------------------
Breaking the habit...

cLFlaVA (Programmer)
22 Sep 04 11:03
fumei-

You are correct, I misgrokked the question...

*cLFlaVA
----------------------------
Breaking the habit...

cLFlaVA (Programmer)
22 Sep 04 11:03
Actually, I grokked it fine:

Quote:

I have added a check box in Excel 2000.  How do I size the check box.  I can change the size of the associated label but can not figure out how to change the size of the box itself.

*cLFlaVA
----------------------------
Breaking the habit...

SkipVought (Programmer)
22 Sep 04 11:04
I cannot replicate your solution.  It happened ONCE, but will not happen again???

Mebe I need to reboot, else I'll go down with das boot.

Skip,

Be advised:  When transmitting sheet music...
If it ain't baroque, don't fax it!

misscrf (TechnicalUser)
22 Sep 04 11:55
ok I said this before.  If you want to resize the CHECKBOX...
Quote:
I have added a check box in Excel 2000.  How do I size the check box.  I can change the size of the associated label but can not figure out how to change the size of the box itself.

then do the following:

1 place checkbox on worksheet

2 right-click checkbox and choose to format control

3 click on the "size" tab

4 increase the height and weight

5 click OK

If that doesn't work, then your question has eluded me!!!!

misscrf

Management is doing things right, leadership is doing the right things

cLFlaVA (Programmer)
22 Sep 04 11:57
While 'weight' is a new property to me, these steps you describe do not work for me.

My solution worked for me, but not for SkipVought.  If this is a one-time solution the poster is looking for, than these solutions may be helpful.  However, they do not seem by any means to be reliable.

*cLFlaVA
----------------------------
Breaking the habit...

misscrf (TechnicalUser)
22 Sep 04 11:58
ok so I did that once, it worked, and now it doesn't.  

Hey, does anyone know how to change the size of the checkbox on an excel worksheet?

misscrf

Management is doing things right, leadership is doing the right things

fumei (TechnicalUser)
22 Sep 04 14:57
Well, as it STILL not answered if this is a Forms checkbox, or an ActiveX checkbox - and resizing them would be a different process;

AND, it is STILL not answered if the issue is to do the resizing programatically, or just resize "real time";

then my final post is:

Yes I do know.  At least with Version 2002.

Ta.

Gerry

misscrf (TechnicalUser)
22 Sep 04 15:09
Fumei, I believe the question is a checkbox on an Excel spreadsheet, not programatically, and it should probably be a forms checkbox. I think!

Go with that, and go with God.

misscrf

Management is doing things right, leadership is doing the right things

JeanetteM (TechnicalUser) (OP)
29 Sep 04 17:50
Thank you cLFlaVA!  This worked!  :)

Quote:


I have found a way.

 - Place a Checkbox on your Worksheet.
 - Right Click, Format Control.
 - Properties Tab.
 - Select Move and Size with cells.
 - Make the cell that it hovers over larger (vert and horiz).

This will make the text look terrible too, however.  I suggest having no caption, then placing a label next to it.

For all your virtual administrative needs visit
http://www3.sympatico.ca/lanceandjeanette

cLFlaVA (Programmer)
29 Sep 04 17:52
Rock On.

*cLFlaVA
----------------------------
Lois: "Peter, you're drunk!"
Peter: "I'm not drunk, I'm just exhausted from stayin' up all night drinking!"

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close