+ Reply to Thread
Results 1 to 3 of 3

Switching between 2 different userforms on 2 different files

  1. #1
    Registered User
    Join Date
    02-08-2019
    Location
    belgium
    MS-Off Ver
    office 365
    Posts
    22

    Switching between 2 different userforms on 2 different files

    I have the following problem: if I want to go from userform 1 (file1) to userform 2 of file2 by means of a command button, this is no problem. But when I want to go back from userform 2 (file2) to userform 1 (file1) file 2 closes which is fine but I get userform 1( file1) neither visible nor open ?

    see 2 sample files

    https://www.excelforum.com/attachmen...1&d=1646303390
    https://www.excelforum.com/attachmen...1&d=1646303390

    have tried to upload but it wont works, sorry
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    08-17-2007
    Location
    Poland
    Posts
    2,242

    Re: Switching between 2 different userforms on 2 different files

    Try as shown in the new attachments. But this is still one great "guerrilla warfare".
    For testing, it is assumed that both files are in the same folder.

    Artik
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    02-08-2019
    Location
    belgium
    MS-Off Ver
    office 365
    Posts
    22

    Re: Switching between 2 different userforms on 2 different files

    Thx Artik,

    Will give it a try.

+ 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. Switching between 2 userforms on different excel-files
    By thomasghi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-05-2019, 09:45 AM
  2. Avoid Switching Sheets, Reference Sheet Without Switching Instead.
    By EnigmaMatter in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-29-2017, 06:59 PM
  3. Excel is spontaneously switching files\workbooks
    By Caladan607 in forum Excel General
    Replies: 5
    Last Post: 04-29-2014, 10:24 AM
  4. Macro help switching between files
    By JSD133 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-03-2011, 05:02 PM
  5. Switching Ink On or Off
    By ACM2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-04-2010, 05:16 PM
  6. switching last name/first name
    By charlie11k in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-31-2009, 11:13 AM
  7. How to create Userforms for different excel files ...
    By nsk1971 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-13-2009, 04:20 PM

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