+ Reply to Thread
Results 1 to 2 of 2

Drop down list disapearing

  1. #1
    Registered User
    Join Date
    10-08-2008
    Location
    England
    Posts
    1

    Drop down list disapearing

    Hi is it possible to have a drop down list in excel that will appear and dissapear depending on a check box is ticked or not ?

    thanks madsp0f x

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    You can enable/disable a Controls toolBox combobox, or change it's visible property according to the checkbox's value.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

+ 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. Drop Down List Question?
    By DJ-Cavity in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-14-2011, 04:48 PM
  2. Drop Down list within a drop down list.
    By nomad3rider in forum Excel General
    Replies: 4
    Last Post: 11-01-2011, 08:53 AM
  3. drop list to another drop list
    By tswid in forum Excel General
    Replies: 1
    Last Post: 08-21-2008, 11:45 PM
  4. Dynamic Drop Down List...with Criteria
    By TimE in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-17-2008, 11:43 AM
  5. conditional drop down list
    By ADSK in forum Excel General
    Replies: 2
    Last Post: 11-25-2007, 04:27 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