+ Reply to Thread
Results 1 to 2 of 2

Default value in list where it is possible to select multiple values

  1. #1
    Registered User
    Join Date
    08-27-2012
    Location
    Denmark
    MS-Off Ver
    Excel 2007
    Posts
    7

    Default value in list where it is possible to select multiple values

    Hi,

    I don't know how long I have tried to solve this problem, but hope you can help.

    The problem is that I have a list (Data validation list).

    In the list it should be possible to select multiple values which I have a macro for.

    Please Login or Register  to view this content.
    Furthermore the list should have a default value which I have a macro for.

    Please Login or Register  to view this content.
    However the sheet should also be protected which you should be able to see in the code.

    The problem is that the default value appears twich in the list. However If I remove the first code then the default code works perfectly but then I can't select multiple values in the list.

    Hope you can help.

    br.

  2. #2
    Registered User
    Join Date
    08-27-2012
    Location
    Denmark
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Default value in list where it is possible to select multiple values

    This is what I mean with The problem is that the default value appears twich in the list

    Untitled.png

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. List where you can select multiple values?
    By rocketgirl in forum Excel General
    Replies: 3
    Last Post: 12-18-2014, 08:31 PM
  2. [SOLVED] Select multiple values from dropdown list
    By DiegoL in forum Excel General
    Replies: 3
    Last Post: 12-10-2014, 06:06 AM
  3. VBA select multiple values in a pivot table field based on a list
    By DD1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-18-2014, 08:28 PM
  4. Userform Combobox - select from list, store this as default each time userform loads
    By thecdnmole in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-19-2014, 07:48 AM
  5. Replies: 2
    Last Post: 11-17-2008, 09:14 PM
  6. [SOLVED] with a drop down list in excel how do I select multiple values
    By Keith H in forum Excel General
    Replies: 1
    Last Post: 07-13-2006, 01:15 PM
  7. Replies: 2
    Last Post: 05-18-2006, 02:40 AM

Tags for this Thread

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