LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #8   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default UserForm Checkboxes

I have found a partial solution to the problem with checkboxes o
optionbuttons appearing as different sizes even though the propertie
(height, width, font, etc) were identical. It turns out that th
spacing between boxes or buttons has some influence on box/button size
In my particular case, the box/button HEIGHT is 18. I found that th
spacing between TOPs of sequential objects must be 22 or more. If les
than 22, some elements were undersized but I could find no pattern t
what happens. In some cases, frames with 2 elements did not care abou
spacing – anything worked. In other two element frames, spacing wa
critical. Same for 3, 4, and 5 element frames. My sense is that ther
is an underlying grid that forces elements to be in certain places an
will adjust element size to accommodate the grid. *This is probably
screen resolution issue.* When I have a few minutes, I will fiddl
with spacing and screen resolution and see what that doe

--
Message posted from http://www.ExcelForum.com

 
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
Checkboxes Elaine Excel Discussion (Misc queries) 6 August 20th 09 01:41 AM
Userform Checkboxes gti_jobert Excel Discussion (Misc queries) 1 January 27th 06 01:21 PM
Userform with Checkboxes Greg B Excel Discussion (Misc queries) 5 November 27th 05 09:32 PM
add multiple checkboxes to userform at runtime gkelle Excel Programming 2 October 16th 03 04:16 PM
How to create in a userform, select all/deselect all checkboxes Intruder Excel Programming 1 July 31st 03 04:53 AM


All times are GMT +1. The time now is 12:33 AM.

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"