+ Reply to Thread
Results 1 to 2 of 2

Thread: Change the width of a combo box in a 2007 custom ribbon?

  1. #1
    Registered User
    Join Date
    07-21-2010
    Location
    Bakersfield, CA
    MS-Off Ver
    Excel 2007
    Posts
    18

    Change the width of a combo box in a 2007 custom ribbon?

    I am customizing the excel ribbon and I have a combo box that will list the numbers 1 through 10. I've got everything working, but the width of the combo box is set for a longer string. How do I make the combo box narrower? I am using the Custom UI Editor for Microsoft Office. Thanks in advance!!
    Last edited by ericsastud; 12-22-2011 at 12:32 PM.

  2. #2
    Forum Guru pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2010
    Posts
    5,155

    Re: How do I change the width of a combo box in a 2007 custom ribbon?

    Hi ericsastud


    Use sizeString="WWWWWWWWWWWW" to size the dropdown

    PHP Code: 
    <dropDown 
                            id
    ="rxddSheetNavigation"
                            
    label="Navigate to:"
                            
    sizeString="WWWWWWWWWWWW"
                            
    supertip="Go to Selected Worksheet from Worksheet Names Collection Dropdown "
                            
    getItemCount="rxdd_ItemCount"
                            
    getItemLabel="rxdd_ListItem"
                            
    onAction="rxdd_Item_Selected"/> 
    regards pike

    If the solution helped please donate
    here to the RSPCA

    Sites worth visiting;

    J&R Solutions - royUK

    AJP Excel Information - Andy Pope

    Spreadsheet Toolbox

    VBA for smarties - snb

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.2.0