+ Reply to Thread
Results 1 to 8 of 8

Drop Down List Question

  1. #1
    Registered User
    Join Date
    02-06-2012
    Location
    Ohio
    MS-Off Ver
    Excel 2007
    Posts
    14

    Drop Down List Question

    When you have a drop down list, is there anyway to have a blank space to be selected?
    Last edited by cody1187; 02-07-2012 at 09:06 AM.

  2. #2
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Drop Down List Question

    Hi

    ....a blank space to be selected?
    Blank space...>>You mean an empty cell??or something else?
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    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
    44,669

    Re: Drop Down List Question

    Sure, if you include a cell in the DV List with nothing in it (or a space)

    Regards, TMS
    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


  4. #4
    Registered User
    Join Date
    02-06-2012
    Location
    Ohio
    MS-Off Ver
    Excel 2007
    Posts
    14

    Re: Drop Down List Question

    Ive added an open cell to the DV List but it wont hold its place in the Drop down list

  5. #5
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Drop Down List Question

    ??
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    02-06-2012
    Location
    Ohio
    MS-Off Ver
    Excel 2007
    Posts
    14

    Re: Drop Down List Question

    thanks, not the brightest over here

  7. #7
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Drop Down List Question

    You are welcome

    ...not the brightest over here
    What you mean by this??

  8. #8
    Registered User
    Join Date
    02-06-2012
    Location
    Ohio
    MS-Off Ver
    Excel 2007
    Posts
    14

    Re: Drop Down List Question

    it was a simple mistake i didnt see

+ 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