+ Reply to Thread
Results 1 to 2 of 2

VBA Combo Box Doesn't Work in Excel 2007

  1. #1
    Registered User
    Join Date
    08-06-2009
    Location
    Littleton, CO
    MS-Off Ver
    Excel 2007
    Posts
    1

    Exclamation VBA Combo Box Doesn't Work in Excel 2007

    When I add a combo box to a user form with VBA 6.5 for Excel 2007, there is no 'List' property listed, and therefore, no way to enter selections into the combo box.

    Do I need to install an optional Excel component I may have left unchecked during the Excel 2007 installation or is there another way to load data into the combo box (at design time) I may not be aware of?

    Also, if it matters, I also have MS Visual Studio 2008 installed. Perhaps there's a way I can have Excel link to that application rather than VBA 6.5?

    Thanks in advance for the advice!

  2. #2
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: VBA Combo Box Doesn't Work in Excel 2007

    Look for "RowSource" in the control properties.

+ 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.6.0 RC 1