+ Reply to Thread
Results 1 to 6 of 6

Excel 2007 : Assigning drop down to a cell using script

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

    Assigning drop down to a cell using script

    Hi,
    I am new to Excel. Please help me with the below problem:

    I have created a button in sheet 1 and on click of this button i have written a code which will create a drop down and also populate values into the drop down. i want this drop down to appear in cell A10 of sheet 1. How can i ensure this?

    Regards,
    Anu
    Attached Files Attached Files

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,057

    Re: Assigning drop down to a cell using script

    Why do you want to do this? hy don't you use Data Validation in Cell A10?

    I'm sure that would have the same effect without having to use code.

    Regards

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

    Re: Assigning drop down to a cell using script

    Hi,
    The cell where i want to put the drop down is not static. Based on a few conditions, i am to decide the cell where the drop down should appear.

    Regards,
    Anu

  4. #4
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,971

    Re: Assigning drop down to a cell using script

    Please Login or Register  to view this content.
    Note: it will work better if you actually connect the code to the button...
    Everyone who confuses correlation and causation ends up dead.

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

    Re: Assigning drop down to a cell using script

    Hi,
    Thanks a lot for the response. It was really helpful. I was able to create the drop downs.

    I have two other queries:
    1. Is it possible for me to name this drop down.
    2. Also, when i select this drop down, i want to get the selected value in the script.

    Is there a solution for the above? Please help.

    Regards,
    Anu

  6. #6
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,971

    Re: Assigning drop down to a cell using script

    Since you have already asked this as a separate question (as well as duplicating this question, so I have just locked the other one), please mark this Solved and continue in that other question.

+ 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