+ Reply to Thread
Results 1 to 22 of 22

open user Form in workbook1 from workbook2

Hybrid View

  1. #1
    Registered User
    Join Date
    06-30-2010
    Location
    Newport New VA
    MS-Off Ver
    Excel 2003
    Posts
    97

    Re: open user Form in workbook1 from workbook2

    Quote Originally Posted by Izandol View Post
    Which module (Module1, or worksheet module, or...?), not which workbook?
    It's not in any module.. I'm sorry but i click on everything in the VBa the code does not exist in a module it exist within the form..

    I attached a picture of the vba with the code for that button opened.
    Attached Images Attached Images

  2. #2
    Registered User
    Join Date
    06-30-2010
    Location
    Newport New VA
    MS-Off Ver
    Excel 2003
    Posts
    97

    Re: open user Form in workbook1 from workbook2

    Ok Izandal I can create the module like you suggested, and are you saying to put the application.run code into the buttonclick command?

  3. #3
    Registered User
    Join Date
    06-30-2010
    Location
    Newport New VA
    MS-Off Ver
    Excel 2003
    Posts
    97

    Re: open user Form in workbook1 from workbook2

    I click the debug on the error code. I attached a picture of the code it highlighted.

    It highlighted the application.run code...
    Attached Images Attached Images

  4. #4
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: open user Form in workbook1 from workbook2

    What is code to open other workbook? Will it be OK to allow user to close this workbook and then have userform reappear automatically?
    • Please remember to mark threads Solved with Thread Tools link at top of page.
    • Please use code tags when posting code: [code]Place your code here[/code]
    • Please read Forum Rules

  5. #5
    Registered User
    Join Date
    06-30-2010
    Location
    Newport New VA
    MS-Off Ver
    Excel 2003
    Posts
    97

    Re: open user Form in workbook1 from workbook2

    How would it know "when" to reappear? Because the user will be working in the workbook or worksheet and when they are finished they would click button to get back to form. So how would VBA/Windows/Excel know when that is?

  6. #6
    Registered User
    Join Date
    06-30-2010
    Location
    Newport New VA
    MS-Off Ver
    Excel 2003
    Posts
    97

    Re: open user Form in workbook1 from workbook2

    Not sure how that would work.. How owuld it know when to open the form?

+ 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. How to bring data from workbook1 to workbook2 by comparing values of workbook2
    By amethystfeb in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-04-2013, 09:38 AM
  2. Workbook1 should start Workbook2
    By KausBorealis in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-03-2012, 10:52 PM
  3. Move tab from Workbook1 to Workbook2 using Macro VBA
    By nachousa in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-08-2010, 11:58 AM
  4. Data from workbook1 to workbook2 every week but in different place in workbook2
    By cheelie in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-29-2007, 06:26 PM
  5. Replies: 1
    Last Post: 05-18-2005, 09:06 AM

Tags for this Thread

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