LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,163
Default I would like to enlarge a checkbox/checkmark to fit my cell.

The box in the checkbox control is not resizable. You can create your own
checkbox fairly easily, though, with a textbox (shape) from the drawing
toolbar. I set the font to be Wingdings 2 and use the "P" character, which
gives a check. The following code set as it's "Assigned Macro" will toggle
it:

Sub TextBox1_Click()
With ActiveSheet.Shapes("Text Box 1").OLEFormat.Object
If .Text = "P" Then .Text = "" Else .Text = "P"
End With
' You can add code here that would be the equivalent of the checkbox's
' _Click, _Change, _BeforeUpdate, or _AfterUpdate event procedures
End Sub

--
- K Dales


"Tim Richards" wrote:

I would like the actual checkbox to be larger.
I realize I can resize the caption box area.
I'm not currently using the caption area, just the actual textbox.
The worksheet I'm designing has alot of checkboxes and they are to small for
my purpose.

 
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
how to customize or enlarge checkbox Wen Le[_2_] New Users to Excel 1 April 28th 07 04:28 PM
enlarge a single cell PTJeff Excel Discussion (Misc queries) 2 March 7th 06 09:29 AM
Checkmark and Value Automatically Appear in Cell xlsmacronewbie Excel Programming 1 July 29th 05 03:59 AM
Cell to accept checkmark or "x" Shadyhosta New Users to Excel 3 December 29th 04 05:09 PM
enlarge built-in checkbox control Lore Leuneog Excel Programming 0 October 24th 04 10:34 PM


All times are GMT +1. The time now is 11:21 PM.

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

About Us

"It's about Microsoft Excel"