+ Reply to Thread
Results 1 to 5 of 5

Userform Populated By Drop Down List Of Range On Another Protected Workbook

  1. 01-05-2016, 06:18 AM #1
    BDBJ1
    BDBJ1 is offline
    Registered User
    Join Date
    06-17-2014
    Location
    UK
    MS-Off Ver
    2013
    Posts
    49

    Post Userform Populated By Drop Down List Of Range On Another Protected Workbook

    I have two workbooks:

    1. Source Data.xslm
    2. Destination.xslm

    On 'Destination.xslm' after clicking on the CommandButton1 is a userform with a combobox-when the user clicks on the combobox I want the dropdown options to be those shown in range A2:A10 in the other Source Data.xslm spreadsheet.

    What VBA code in the Userform do I need to do this?

    is it necessary to have both open at the same time as this is not ideal.

    Both workbooks are protected (password is "a" for both).

    I have attached both workbooks below.

    Thanks in advance.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 01-05-2016, 06:23 AM #2
    Keebellah
    Keebellah is offline
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: Userform Populated By Drop Down List Of Range On Another Protected Workbook

    Hi,
    I think it's quite simple, I'll try something and update, the range will always be A2:A10?
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you
    Reply With QuoteRegister To Reply
  3. 01-05-2016, 06:32 AM #3
    BDBJ1
    BDBJ1 is offline
    Registered User
    Join Date
    06-17-2014
    Location
    UK
    MS-Off Ver
    2013
    Posts
    49

    Re: Userform Populated By Drop Down List Of Range On Another Protected Workbook

    No-the range is dynamic so it will be A2:Axxx
    Reply With QuoteRegister To Reply
  4. 01-05-2016, 07:09 AM #4
    Keebellah
    Keebellah is offline
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: Userform Populated By Drop Down List Of Range On Another Protected Workbook

    Okay, this will do.
    I just coded the ComboBox.
    It does check if the Source Data file is opened
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 01-05-2016, 07:18 AM #5
    BDBJ1
    BDBJ1 is offline
    Registered User
    Join Date
    06-17-2014
    Location
    UK
    MS-Off Ver
    2013
    Posts
    49

    Re: Userform Populated By Drop Down List Of Range On Another Protected Workbook

    Fantastic! Thanks very much.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. UserForm Drop Down List Using VLOOKUP from another workbook
    By BDBJ1 in forum Excel General
    Replies: 1
    Last Post: 12-21-2015, 08:20 AM
  2. [SOLVED] Pre-populated drop-down list from selection made in drop-down list
    By jmaggols in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-15-2015, 12:26 PM
  3. Userform Populated with range from another excel file
    By jsabo in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 05-28-2014, 09:49 AM
  4. [SOLVED] Drop Down List populated from Index Match
    By jonesyp in forum Excel General
    Replies: 6
    Last Post: 03-03-2014, 03:23 AM
  5. [SOLVED] Drop-down list Populated by a Subset of a larger list
    By RJH in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-11-2010, 07:17 AM
  6. Drop-down list populated by SQL recordset?
    By LadyReader in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-09-2009, 08:33 AM
  7. Can a cell have a drop down list and can also be auto populated
    By Adrian in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-17-2005, 02:06 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1