Results 1 to 9 of 9

Drop down list does not work same as type

Threaded View

  1. #1
    Registered User
    Join Date
    06-20-2013
    Location
    India, Pune
    MS-Off Ver
    Excel 2003
    Posts
    6

    Drop down list does not work same as type

    Hello,
    I am tring to write a code to change color of cell when cell values matches perticular value.
    Attached is the test file.
    When cell value of B1 becomes "1" color changes to red.
    The code works well if I type in cell B1.
    When I use drop down list (Data/Validation/List) it doesn't work.

    PLease help me.

    Regards,
    SWapnil
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Drop Down list to make it act when type in any letter
    By Alexb77 in forum Excel General
    Replies: 4
    Last Post: 10-09-2013, 06:02 PM
  2. Drop down list that narrows as you type
    By penguintar in forum Excel General
    Replies: 1
    Last Post: 11-16-2011, 09:20 AM
  3. Drop down combo box list on type
    By sick stigma in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-20-2009, 09:12 AM
  4. How to type to select something in a Drop down list?
    By Djanvk in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-07-2008, 12:56 AM
  5. [SOLVED] No drop down list type-ahead?
    By Launen in forum Excel General
    Replies: 2
    Last Post: 10-18-2005, 01:05 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