+ Reply to Thread
Results 1 to 5 of 5

urgent - Drop down list if another cell has a value

  1. #1
    Registered User
    Join Date
    05-14-2013
    Location
    southampton
    MS-Off Ver
    Excel 2003
    Posts
    76

    urgent - Drop down list if another cell has a value

    Hello wise and skilled excel users,

    I have a drop-down list that I only want available if K5 cell has "Yes" value.

    I tried this formula (with Andrew being the list range name) but it comes up with the error 'source must be delimited

    Please Login or Register  to view this content.
    Any thoughts?

  2. #2
    Valued Forum Contributor ranman256's Avatar
    Join Date
    07-29-2012
    Location
    Kentucky
    MS-Off Ver
    Excel 2003
    Posts
    1,176

    Re: urgent - Drop down list if another cell has a value

    Is this a form control or activeX control?

  3. #3
    Registered User
    Join Date
    05-14-2013
    Location
    southampton
    MS-Off Ver
    Excel 2003
    Posts
    76

    Re: urgent - Drop down list if another cell has a value

    Just control. I don't have activeX I don't think..

  4. #4
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: urgent - Drop down list if another cell has a value

    This is likely a VBA project.

    I have found nothing to indicate that this is possible using Data Validation and worksheet functions.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  5. #5
    Registered User
    Join Date
    05-14-2013
    Location
    southampton
    MS-Off Ver
    Excel 2003
    Posts
    76

    Re: urgent - Drop down list if another cell has a value

    I'm not versed enough in VBA to know where to begin..
    Last edited by ld2x07; 10-24-2014 at 05:15 AM.

+ 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. URGENT: auto expanding drop-down list?
    By ld2x07 in forum Excel General
    Replies: 6
    Last Post: 05-06-2014, 08:20 AM
  2. [SOLVED] Pull data using drop-down list (URGENT - ATTACHED)
    By ld2x07 in forum Excel General
    Replies: 3
    Last Post: 05-14-2013, 09:29 AM
  3. Drop Down List Box HELP URGENT PLEASE!
    By lucasprss in forum Excel General
    Replies: 12
    Last Post: 08-03-2012, 11:32 AM
  4. Excel 2007 : Macros for Drop Down to toggle between sheets
    By sheikhowais in forum Excel General
    Replies: 1
    Last Post: 03-28-2012, 03:09 AM
  5. [SOLVED] how do I link a drop down list entry to a new drop down cell?
    By lmunzen in forum Excel General
    Replies: 1
    Last Post: 08-15-2006, 12:05 PM

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