+ Reply to Thread
Results 1 to 3 of 3

Drop drown list input for case statement

Hybrid View

  1. #1
    Registered User
    Join Date
    10-01-2014
    Location
    Melbourne,Australia
    MS-Off Ver
    2010
    Posts
    21

    Drop drown list input for case statement

    Hello All,
    In my sheet I have the cell for drop down list. When the user select the option from the list. This will be one of the Cases in Select Statement. I wonder if we can do that with vba?

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: Drop drown list input for case statement

    Incomplete explanation about what you are trying to do.

    Please make it more descriptive


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Registered User
    Join Date
    10-01-2014
    Location
    Melbourne,Australia
    MS-Off Ver
    2010
    Posts
    21

    Re: Drop drown list input for case statement

    Thank you Sixthsense, but I got it worked!

+ 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. Case statement based on value within drop-down box
    By aaron.irvine in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-30-2013, 10:23 PM
  2. Drown Down List on Multiple Sheets
    By mfaustin in forum Excel General
    Replies: 2
    Last Post: 07-25-2013, 04:34 PM
  3. [SOLVED] Excel 2003 - Creating Named ranges for a validation list box using a case statement
    By DebbieEdwards in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-17-2013, 08:43 AM
  4. Drop down list based on input of two other drop down list
    By mitesh55 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-09-2010, 07:41 PM
  5. [SOLVED] input range in drop down list
    By Otto in forum Excel General
    Replies: 3
    Last Post: 07-27-2005, 05: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