+ Reply to Thread
Results 1 to 4 of 4

Lookup closed workbook from UserForm

  1. #1
    Registered User
    Join Date
    10-25-2007
    Location
    Melbourne, Australia
    Posts
    27

    Lookup closed workbook from UserForm

    Hi, Everyone.
    I am trying to conduct a lookup to range in a closed workbook, based on the value in a combo box, in order to fill a value in a text box on a userform.
    The combobox lists are filled by accessing a closed workbook. I found a solution to achieve that, but not how to conduct a lookup.
    The following code snippet crashes out with the error "Object doesn't support this property or method."

    HTML Code: 
    Can anyone please advise on the correct approach to do a lookup to another workbook from within a Userform?
    Any help very appreciated.
    Thanks.
    jagman

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    Use the .Find method, there's many examples here. Something like this
    Please Login or Register  to view this content.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Registered User
    Join Date
    10-25-2007
    Location
    Melbourne, Australia
    Posts
    27
    Thanks again for your help, RoyUK. That ammendment works perfectly.
    You are very generous with your time and expertise. It is very appreciated by those of us just starting out in vba.
    jagman.

  4. #4
    Registered User
    Join Date
    08-18-2009
    Location
    FL, USA
    MS-Off Ver
    Excel 2019
    Posts
    23

    Re: Lookup closed workbook from UserForm

    Please Help!

    Thanks to everyone here for all the info that is shared, It's helped me alot.
    I am trying to do this same thing, I have a multipage userform with a ComboBox on each page.
    I have been able to pull the data from a closed workbook to populate the comboBox on the first page, but then I also need to do a VLOOKUP to populate 5 Textboxes using data from the same "closed' workbook that populated the ComboBox.
    I have not even tried yet to get the other ComboBoxes and TextBoxes to pull data from different "closed" workbooks..

    Any help will be greatly appreciated.

    Thanks You

+ 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. Copy worksheets to new workbook
    By Edward HS in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-29-2008, 07:16 PM
  2. Activate workbook before close event when excel is closed
    By RobynC in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-05-2007, 06:19 AM
  3. Close workbook if form is closed
    By Sirishgreen in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-30-2007, 08:47 AM
  4. Populate Dropdown Box From Closed Workbook
    By joe12613 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-31-2007, 10:58 AM
  5. problem accessing lookup list from sheet in another workbook
    By PaulC in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-31-2007, 09:54 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1