+ Reply to Thread
Results 1 to 3 of 3

WorkSheet ActiveX Combobox entry problem

  1. #1
    Forum Contributor
    Join Date
    01-02-2007
    Location
    Australia NSW
    MS-Off Ver
    2013
    Posts
    495

    Question WorkSheet ActiveX Combobox entry problem

    The below code populates my sheets Combobox named (ROLL1).

    The problem is when i aded the ROLL1.Clear to prevent duplicate populations of the combobox, when a value is now selected, upon exiting the value is not retained.

    Please Login or Register  to view this content.
    Why is the selected value not retained when exiting the combobox?

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: WorkSheet ActiveX Combobox entry problem

    because the event fires again when you select the item. why are you using that event to populate the control instead of say the worksheet activate event or workbook open?
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  3. #3
    Forum Contributor
    Join Date
    01-02-2007
    Location
    Australia NSW
    MS-Off Ver
    2013
    Posts
    495

    Re: WorkSheet ActiveX Combobox entry problem

    I didn't realise the DropButton event fired also when selecting an item.

    I guess i assume that when an item would be selected, that the Change event would then be the trigger.

+ 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