+ Reply to Thread
Results 1 to 11 of 11

Unique drop down list option for each column

  1. #1
    Registered User
    Join Date
    11-16-2017
    Location
    Belgium
    MS-Off Ver
    2016
    Posts
    5

    Thumbs up Unique drop down list option for each column

    Hey,

    I am trying to make columns that have one unique option.

    First check this image: https://i.imgur.com/uxwX57G.png


    excellll.png

    Like you can see there is the option to take the circle icon in the DDL.

    But I want it only to be possible at 1 cell per column.

    example: the circle icon is selected at the first row cell. When I select the circle icon in the third row. The first row cell gets empty.

    Thanks for reading,

    hope you can help me.

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,000

    Re: Unique drop down list option for each column

    If I understand correctly you cannot have both a value and a formula in a cell.

    So you select row (column with WI4) with a circle then select ow 3 and add a circle in the same column ?

    If you want row 1 entry cleared you will need to use VBA.

  3. #3
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Unique drop down list option for each column

    It looks like you have used Windings2 font

    Place this code in the SHEET module
    Please Login or Register  to view this content.
    Working example attached
    - in Windings2
    O and P are the tick and cross
    8 is the symbol not to be repeated

    Did you use a combo box to allow the font to be amended in the dropdown?
    - adapt the code to match your situation
    Attached Files Attached Files
    Last edited by kev_; 11-16-2017 at 08:38 AM.
    Click *Add Reputation to thank those who helped you. Ask if anything is not clear

  4. #4
    Registered User
    Join Date
    11-16-2017
    Location
    Belgium
    MS-Off Ver
    2016
    Posts
    5

    Re: Unique drop down list option for each column

    Thanks a lot!

    I don't know alot about macro's and visuals basic (and excel :p) but there was one bug in the code.
    => when I want to choose a value it always became an 8.

    I fixed it with a litlte change.
    Please Login or Register  to view this content.
    Thank you for the quick responds.

  5. #5
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Unique drop down list option for each column

    You are welcome
    Thanks for the rep
    You can mark the thread as SOLVED by clicking on Thread Tools at top of thread

  6. #6
    Registered User
    Join Date
    11-16-2017
    Location
    Belgium
    MS-Off Ver
    2016
    Posts
    5

    Re: Unique drop down list option for each column

    Is it also possible to change the 'O', 'P' & '8' to icons in the DDL?

  7. #7
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Unique drop down list option for each column

    Your image shows that you have already got a DDL with icons. To avoid having to re-create...
    Please attach your workbook and I will modify the code to match your file
    - Click on GoAdvanced
    - Look below and click on ManageAttachments
    - Follow instructions on screen

  8. #8
    Registered User
    Join Date
    11-16-2017
    Location
    Belgium
    MS-Off Ver
    2016
    Posts
    5

    Re: Unique drop down list option for each column

    Yea but i changed the UNICODE icons to the windings 2 font
    Attached Files Attached Files

  9. #9
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Unique drop down list option for each column

    Your original picture included icons in DDL.
    Please attach your original file

    thanks

  10. #10
    Registered User
    Join Date
    11-16-2017
    Location
    Belgium
    MS-Off Ver
    2016
    Posts
    5

    Re: Unique drop down list option for each column

    I attached it in the previous responds.

  11. #11
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Unique drop down list option for each column

    I am away from PC (and cannot verify) but from memory the file you attached did not include icons in DDL. I meant the original file with unicode icons in DDL. Sorry for not being clear.

    Per Post#1 picture - with icons

    Dropdown1.jpg

    Per Post#8 attachment - without icons

    Dropdown2.jpg
    Last edited by kev_; 11-20-2017 at 01:26 PM.

+ 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. Replies: 5
    Last Post: 10-21-2017, 08:03 PM
  2. 'Select all' option in a drop down list
    By james19 in forum Excel General
    Replies: 3
    Last Post: 03-12-2016, 11:14 AM
  3. Creating a SUM when choosing a option from a Drop Down List
    By whiterosetools in forum Excel General
    Replies: 4
    Last Post: 05-20-2014, 09:29 AM
  4. [SOLVED] Drop down list to allow only unique values in a column
    By Mzun in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-25-2013, 03:07 AM
  5. Replies: 7
    Last Post: 05-11-2012, 02:00 PM
  6. Help: allow a blank as an option in a drop down list
    By lmm07468 in forum Excel General
    Replies: 6
    Last Post: 06-26-2008, 09:55 AM
  7. Allow drop-down list not an option? Help
    By JetsVille in forum Excel General
    Replies: 1
    Last Post: 06-05-2007, 03:04 PM

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