+ Reply to Thread
Results 1 to 2 of 2

Combo Box - No choices!

  1. #1
    Registered User
    Join Date
    07-01-2007
    Posts
    32

    Combo Box - No choices!

    I have been trying to create a simple combo box on a user form I can create the form, add a combo box and think code it correctly. However, when the form is opened these are no choices. I have added a text file with the code.

    The como box is named cboNames but I haven't changed any other settings.

    Grateful if someone could offer some help.
    Attached Files Attached Files
    Last edited by artizan; 10-09-2008 at 12:04 PM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436
    You create the initial event yourself rather than picking it from the dropdowns in the editor.
    In doing so you used the routine name Userform1_Initialize.

    Please Login or Register  to view this content.
    So your code is simply a private routine rather than Event code.
    Cheers
    Andy
    www.andypope.info

+ 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. Combo Box Choices Won't Propogate
    By teddybouch in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-24-2008, 06:07 PM
  2. Dynamically add pop up combo box with a click event
    By dovee in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-11-2008, 12:27 PM
  3. Sorting Data in Multiple Combo Boxes
    By ElsieC in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-18-2008, 10:26 AM
  4. Filter data using Combo Boxes
    By gsrai31 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-28-2007, 04:16 AM
  5. cascading combo boxes
    By dkinnz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-05-2007, 05:37 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