Consulting

Results 1 to 3 of 3

Thread: Need to link drop down list from range in xlsm (Add-In)

  1. #1

    Need to link drop down list from range in xlsm (Add-In)

    Dear All,

    I need to link drop down list from range that saved in xlsm (Add-In). I could able to link it to lookup formula but in Data Validation I couldn't do it.
    Lookup example:
    B1 is =VLOOKUP(A1,My_ADDINS.xlam!MyRange,2,FALSE)
    Where My_ADDINS.xlam is the Add-In, MyRange is the range.

    I tried to use the same method in the source of the Data Validation as follow but it didn't work with me.
    =My_ADDINS.xlam!MyList
    where my MyList is the range name saved in the My_ADDINS.xlam file.

    Any one can help please.

    Thank you

  2. #2
    VBAX Regular
    Joined
    Sep 2013
    Posts
    8
    Location
    the problem might be that they are not part of the same file/project... you can easily import the data from one file into a sheet in the other workbook tho... that's just a simple copy/paste routine in VBA

    import it, process it, and then delete it

    have you tried testing it with both sheets in the same book?

    VLOOKUPs really suck

  3. #3
    VBAX Master Aflatoon's Avatar
    Joined
    Sep 2009
    Location
    UK
    Posts
    1,598
    Location
    Try creating a defined name in the workbook with the data validation that refers to =My_ADDINS.xlam!MyList and then use that new name as the DV list source.
    Be as you wish to seem

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •