+ Reply to Thread
Results 1 to 2 of 2

Refer to worksheet combo box

  1. #1
    Registered User
    Join Date
    11-15-2010
    Location
    Leicester
    MS-Off Ver
    Office 365
    Posts
    41

    Refer to worksheet combo box

    Hi

    I have a combo box on my work sheet which I want to be able to clear. (not remove the items, just make it blank until the user selects another item in the list).

    This works
    Please Login or Register  to view this content.
    But, can I do it without selecting something like.... (obviously this doesn't work)
    Please Login or Register  to view this content.
    Also, am I better of using the activex controls instead???

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    47,522

    Re: Refer to worksheet combo box

    Can't you just do:

    Please Login or Register  to view this content.


    Regards
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ 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