+ Reply to Thread
Results 1 to 6 of 6

Control width and Depth off

  1. 11-05-2014, 10:48 AM #1
    steven_b46
    steven_b46 is offline
    Registered User
    Join Date
    10-10-2013
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2010
    Posts
    50

    Control width and Depth off

    Hi,

    I've got functions that build active-x controls at runtime; but they are drawing larger than what I'm asking for.

    Example:

    Please Login or Register  to view this content.
    Example:

    cWidth x cHeight = 223.5 x 31.5

    Getting:

    Width x Height =297.75 x 42.75

    This makes no sense to me. Any idea?
    Reply With QuoteRegister To Reply
  2. 11-05-2014, 10:53 AM #2
    romperstomper
    romperstomper is offline
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,280

    Re: Control width and Depth off

    How are you testing the settings afterwards?

    Is the page zoom set to something other than 100%?
    Remember what the dormouse said
    Feed your head
    Reply With QuoteRegister To Reply
  3. 11-05-2014, 11:22 AM #3
    steven_b46
    steven_b46 is offline
    Registered User
    Join Date
    10-10-2013
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2010
    Posts
    50

    Re: Control width and Depth off

    Quote Originally Posted by romperstomper View Post
    How are you testing the settings afterwards?

    Is the page zoom set to something other than 100%?
    Checking the properties of the control after they are drawn.
    Reply With QuoteRegister To Reply
  4. 11-05-2014, 11:40 AM #4
    romperstomper
    romperstomper is offline
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,280

    Re: Control width and Depth off

    And the page zoom?
    Reply With QuoteRegister To Reply
  5. 11-05-2014, 12:11 PM #5
    steven_b46
    steven_b46 is offline
    Registered User
    Join Date
    10-10-2013
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2010
    Posts
    50

    Re: Control width and Depth off

    Quote Originally Posted by romperstomper View Post
    And the page zoom?
    zoom is at 100%
    Reply With QuoteRegister To Reply
  6. 11-05-2014, 12:12 PM #6
    romperstomper
    romperstomper is offline
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,280

    Re: Control width and Depth off

    I can't replicate that in 2010, though I would add that ActiveX controls on worksheets are notoriously buggy, especially as regards resizing themselves.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Active X control buttons changing to width=0 when unhide columns
    By tlacloche in forum Excel General
    Replies: 1
    Last Post: 07-25-2014, 04:15 AM
  2. Calendar Control Pop Up Set Height and Width
    By greatwent in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-06-2013, 01:25 PM
  3. In depth FTP question.
    By swoop99 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-22-2012, 09:20 AM
  4. Pivot Tables - In Depth
    By Cecil in forum Excel General
    Replies: 2
    Last Post: 06-01-2006, 04:50 PM
  5. Excel Depth
    By Manish in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 09-28-2005, 01:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1