+ Reply to Thread
Results 1 to 4 of 4

Form ComboBox problem

  1. #1
    Registered User
    Join Date
    04-12-2006
    Posts
    35

    Form ComboBox problem

    Finding numerous problems with carrying out tasks with the form comboBox that are straight forward using the control combobox, here is m latest problem...
    Setting comboBox to display the first item in the list. I have populated my forms comboBox with data when the workbook is loaded, I have not used the input range property from right clicking the control. I have then tried to set the comboBox to display the first item in the comboBox using the following:

    dim Ddown as DropDown
    set Ddown = DropDowns("Drop Down 1")

    Ddown.Text = myDD.List(1)

    The problem I have now is that no matter what item i select from the list it will not change and the value remains as the 1st item in the list. Why does this happen with this type of comboBox and not the control comboBox?

    Thanks

  2. #2

    Re: Form ComboBox problem

    cmpcwil2,

    Forgive me if I have misunderstood your problem. But as a quick
    response off the top of my head try replacing...

    Ddown.Text = myDD.List(1)

    with...

    Ddown.ListIndex = 1

    HTH,
    Nick.


  3. #3

    Re: Form ComboBox problem

    cmpcwil2,

    Forgive me if I have misunderstood your problem. But as a quick
    response off the top of my head try replacing...

    Ddown.Text = myDD.List(1)

    with...

    Ddown.ListIndex = 1

    HTH,
    Nick.


  4. #4
    Registered User
    Join Date
    04-12-2006
    Posts
    35
    Thank you works fine, why didn't I think of that!

+ 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