+ Reply to Thread
Results 1 to 2 of 2

Form to display the values of another workbook

  1. #1
    Valued Forum Contributor saravnepali's Avatar
    Join Date
    01-14-2019
    Location
    Sydney Australia
    MS-Off Ver
    2010
    Posts
    447

    Form to display the values of another workbook

    I have two workbooks Wb1 & Wb2.

    The wb1 is has a userform and I can have the userform visible while the sheet cells are selected. So, the userform can display the cells values of the sheets that I have selected.

    However, I cannot have the same userform in modeless form and select the Wb2.

    Is there a way for this ?
    If you think someone helped you, click on the "* Add Reputation" as a way to say thank you.

    If your problem is solved, go to Thread Tools and select Mark This Thread Solved

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: Form to display the values of another workbook

    You need to provide more information as I was able to show a modeless userform and select cells from 2 different workbooks.
    Cheers
    Andy
    www.andypope.info

+ 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. Display a Form based on multiple cell values
    By jcbarte in forum Excel General
    Replies: 2
    Last Post: 09-03-2019, 05:41 AM
  2. Replies: 3
    Last Post: 08-22-2018, 06:42 PM
  3. VBA Form -- Display Values based on dependent lists
    By zaveed in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-24-2013, 11:46 AM
  4. Display the values in form that pull from another sheet which should not the editable
    By gopalkacat in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-19-2012, 03:48 PM
  5. [SOLVED] Conditionally Sum Values in Column and Display Sum in Form Field
    By Southfish in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-22-2012, 08:14 PM
  6. [SOLVED] Display a form prior to workbook being displayed
    By pkm in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-22-2006, 03:10 PM
  7. How do you display a VBA user form when starting excel workbook?
    By dant in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-13-2005, 08: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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1