+ Reply to Thread
Results 1 to 4 of 4

Resize font in ComboBox if item is selection.

  1. #1
    Registered User
    Join Date
    10-20-2014
    Location
    Arkansas
    MS-Off Ver
    2010
    Posts
    41

    Resize font in ComboBox if item is selection.

    Ok I have a ComboBox that when Standing Seam is selected the font needs to resize to 11 other wise it needs to be 12. Any ideas would be great.
    This was something I threw together having little to no knowledge of vba, it didn't work.

    Please Login or Register  to view this content.
    Last edited by CtrlAltDelete; 10-28-2014 at 10:59 AM.

  2. #2
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: Resize font in ComboBox if item is selection.

    Try this:-
    The code must be in the "Combobo1_change" Event
    Right click the box in Design mode and select "View Code"
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    10-20-2014
    Location
    Arkansas
    MS-Off Ver
    2010
    Posts
    41

    Re: Resize font in ComboBox if item is selection.

    It worked perfectly, thank you very much.

  4. #4
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: Resize font in ComboBox if item is selection.

    You're welcome

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. selecting an item in combobox, the item does not get selected
    By AVM in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-14-2014, 05:14 AM
  2. [SOLVED] fill combobox selection based on a selection from the first combobox
    By Monza in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-14-2013, 07:34 PM
  3. Combobox: How to determine the location of the selected item if combobox has rowsource
    By ahsanzafar in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-11-2012, 03:24 PM
  4. Go to Specific Range through ComboBox Item Selection
    By loknath in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-17-2012, 06:47 AM
  5. How do you resize the font in a drop-down menu?
    By Tim Britton in forum Excel General
    Replies: 2
    Last Post: 02-21-2005, 07:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1