+ Reply to Thread
Results 1 to 2 of 2

Create a selecting list

  1. #1
    Registered User
    Join Date
    08-07-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    62

    Create a selecting list

    Hi all,

    I am trying to create a list from where all the fields are visible and you can just click on them.
    It is not a drop down list. It's a list where all posibilities qre visible and you can just click on them.
    It is probably not even done with a list or with validation data.
    Thank you,

    Daniel

  2. #2
    Valued Forum Contributor
    Join Date
    10-26-2008
    Location
    Birmingham, UK
    MS-Off Ver
    All versions up to 2010
    Posts
    1,025

    Re: Create a selecting list

    Hi Daniel
    I found some code on a different forum that does just what you are after.
    Basically you double click a cell and it turns RED, double click again and it turns the RED off.
    The code sits behind the worksheet in the attached sample Workbook, the code is not in a Module.
    Hope this helps.
    Good luck.
    Tony
    Attached Files Attached Files

+ 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