Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
RJD RJD is offline
external usenet poster
 
Posts: 6
Default Making a "Check Box" Larger

Hi,

I figured out how to insert a check box that automatically enters a tick
mark in the box when I click on it. However, the box is pretty small. How do
I change the size of the check box and the tick mark?

RD
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 15,768
Default Making a "Check Box" Larger

As far as making the check box bigger -- you can't!

A kludge work-around is to increase the zoom. Increasing the zoom will make
the check box bigger but it will also make *everything* bigger. What you
could do is use a smaller text font on the entire sheet, like say font size
6, then if you increase the zoom the check box gets bigger and the size 6
font will also get bigger. If you experiment you can get the check box to
the size you want and at the same time get the font size back to what it
originally was (or very close).

For example, if your default font size is 10, format the entire sheet to use
a size 6 font. Then increase the zoom. The check box gets bigger and at the
same time the size 6 font will get bigger to the point that it looks like
the original size 10 font.

--
Biff
Microsoft Excel MVP


"RJD" wrote in message
...
Hi,

I figured out how to insert a check box that automatically enters a tick
mark in the box when I click on it. However, the box is pretty small. How
do
I change the size of the check box and the tick mark?

RD



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
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell Steve Kay Excel Discussion (Misc queries) 2 August 8th 08 01:54 AM
when a "check box" is checked, a "result" to be shown in another c Lisa Ann Kashner Excel Discussion (Misc queries) 2 November 6th 07 02:32 AM
Check if cells contain the word "Thailand", return "TRUE" ali Excel Worksheet Functions 7 September 14th 07 09:53 AM
How can I check the "P" or "A" in the attendance sheet Capricorn Excel Worksheet Functions 1 June 8th 06 12:00 PM
create links to check boxes marked "good" fair"and "bad" pjb Excel Worksheet Functions 3 April 20th 06 02:17 AM


All times are GMT +1. The time now is 04:05 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"