+ Reply to Thread
Results 1 to 1 of 1

Excel 2007 : get selected value of a drop down using script

  1. #1
    Registered User
    Join Date
    08-31-2010
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    9

    get selected value of a drop down using script

    Hi,

    Please help me with the following:

    I have attached a file. In sheet 2 of this file, there is a button and on click of this button i have written a code for creating drop down which will appear in sheet1. I am creating 2 drop downs as per the code i have given.
    1. i want to write a value change listener for drop down 1.

    2. Also i want to retrieve the value i selected in drop down 1.

    Is this possible?

    PS: As per my requirement, i have to create the drop downs dynamically. Hence i am not able to assign a name to the drop down and assign a macro to the same. Please help.

    Regards,
    Anu
    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