Results 1 to 3 of 3

Combo box display to display blank - not the last value - how?

Threaded View

barryleajo Combo box display to display... 08-22-2010, 05:52 PM
shg Re: Combo box display to... 08-22-2010, 05:54 PM
barryleajo Re: Combo box display to... 08-22-2010, 06:19 PM
  1. #1
    Valued Forum Contributor
    Join Date
    06-19-2010
    Location
    Holywell, N Wales, UK
    MS-Off Ver
    Excel 2013
    Posts
    470

    Combo box display to display blank - not the last value - how?

    Hi Everyone
    I have searched the forum and this seems to be a recurring problem but I can't find a solution - any help please?

    I am using a combo box on a user form which is populated using the RowSource property.
    It functions OK. I need the same values to be available all the time i.e. Low, Med, High.

    When the user form first runs the Combo box displays blank and allows the items to be selected using the drop down arrow - no problem - and this is what I want.

    However when I '.Hide' the form and then call it back again (with '.Show') it still displays the last value.

    How can I get the combo box to display blank again each time the user form is called?

    I have tried .Clear and setting .Value all to no avail (presumably because it is pre-populated using RowSource?).....help please!

    WTIA

    barry
    Last edited by barryleajo; 08-22-2010 at 06:19 PM.

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