#1   Report Post  
MarkT
 
Posts: n/a
Default check box size

Is there a way to change the size of a checkbox? I am working in a
spreadsheet that will not allow me to change the size of the box itself.

Thanks as always for your help!

Mark
  #2   Report Post  
tra
 
Posts: n/a
Default check box size

You could cheat, and use a label.
From the control toolbox, draw a label and set its BorderStyle to 1 -

fmBorderStyleSingle. Set its font to Wingdings and set its font size to
whatever best fits inside the label. Give the label the following code
in VBA:

Private Sub Label1_Click()
If Label1.Caption = "ü" Then
Label1.Caption = ""
Else
Label1.Caption = "ü"
End If
End Sub

(if you have named the label something different then subsitute Label1
with whatever you named it).

If you use this method, then, when referencing the label in code, if
Label1.Caption = "ü" then it's ticked, otherwise it's not ticked.
However, if you use this method, you cannot use the keyboard to operate
it.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Font Size in Check Box Beetlejuice Excel Discussion (Misc queries) 2 August 25th 05 02:12 PM
check box size (Not Small Enough) rsilberfarb Excel Discussion (Misc queries) 1 May 6th 05 12:27 AM
Customize page size puzzled Setting up and Configuration of Excel 0 February 18th 05 05:41 AM
Forms Check Box Font Size gjs Excel Discussion (Misc queries) 2 February 2nd 05 05:37 PM
check box formatting jt Excel Discussion (Misc queries) 0 January 18th 05 03:49 PM


All times are GMT +1. The time now is 06:38 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"