+ Reply to Thread
Results 1 to 5 of 5

Simple way to use combo box from Control Toolbox?

Hybrid View

ChristiaanV Simple way to use combo box... 04-09-2008, 10:57 PM
shg If you don't do VBA, you... 04-09-2008, 11:51 PM
royUK After adding your combobox to... 04-10-2008, 01:35 AM
mikerickson The font size of the list in... 04-10-2008, 01:53 AM
ChristiaanV Thanks very much for all the... 04-10-2008, 02:15 PM
  1. #1
    Registered User
    Join Date
    08-10-2006
    Location
    Los Angeles, California
    MS-Off Ver
    2013 64-bit
    Posts
    39

    Simple way to use combo box from Control Toolbox?

    Hi,

    I hate the fact that I can't change the microscopic font size in a forms Combo Box. I'd like to use the Combo Box from the Control Toolbox instead--except I know nothing about VBA. By bringing up the Properties of the Control Toolbox I add to the sheet, is there a simple way I can:
    • Change the font size
    • Display a list based on a named range
    • Link the list choice to an outcome cell or whatnot...

    Thanks in advance, even if the answer is "no."
    Christiaan V

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689
    If you don't do VBA, you don't want controls from the Control Toolbox. Their ouput is not linked to a cell, they have a click event that you need to process in the appropriate sheet module.

    Unless you're ready to learn VBA, stick with the Forms controls.
    Last edited by shg; 04-09-2008 at 11:54 PM.

  3. #3
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    After adding your combobox to the sheet you need to access it's prperties from the toolbox. You must be in Design View - the setsquare icon.

    The Font property allows you to change the font type & clicking the small button to the right gives you more options including size.

    The ListFillRange property allows you to define the source, type in the name or address of your range.

    To add the selection to a specific cell, as shg says, use the Click event. Click <View Code> & add this

    Option Explicit
    
    Private Sub ComboBox1_Change()
    'write to A1 of active sheet
    Cells(1, 1).Value = Me.ComboBox1.Value
    End Sub
    Last edited by royUK; 04-10-2008 at 02:34 PM.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  4. #4
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229
    The font size of the list in a Forms combobox or list box can be controlled by changing the Style Normal.
    Not all of the properties affect the combobox's list, but font name and size can be controlled this way. (The spacing between the lines in the list does not change to fit.)
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

  5. #5
    Registered User
    Join Date
    08-10-2006
    Location
    Los Angeles, California
    MS-Off Ver
    2013 64-bit
    Posts
    39
    Thanks very much for all the help.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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