+ Reply to Thread
Results 1 to 2 of 2

Make the main form visible and rest should be hidden

  1. #1
    Forum Contributor
    Join Date
    02-20-2009
    Location
    bristol
    MS-Off Ver
    Excel 2003
    Posts
    883

    Make the main form visible and rest should be hidden

    Hi All

    I got 4 userforms and now I want to make just the main userform visible and rest of the 3 userforms invisible so that when somebody enters the data in the main form then I want to copy the values in other forms also.

    Can anyone please guide me how to do this? I am writing the following code but this way the 3 side forms are visible but i want them to hide under frmmain.
    Please Login or Register  to view this content.
    Thanks

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2505
    Posts
    27,234

    Re: Make the main form visible and rest should be hidden

    Why do you want them to be invisible? Why not simply not show them? You can still execute code that copies values into them if they are not being shown. Just show them when you need them to be seen. However, you do not want to use Unload when you close them, use Hide to preserve their states.

    It would be helpful to see all your code.
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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. [SOLVED] Randomly choose one of several images to make visible, rest invisible.
    By Kramxel in forum PowerPoint Programming
    Replies: 1
    Last Post: 10-23-2013, 07:22 AM
  2. [SOLVED] Hide excel sheets but visible after clicking on hyperlink from main sheet.
    By naveen4pundir in forum Excel General
    Replies: 2
    Last Post: 03-29-2012, 02:16 AM
  3. Filtering Form Criteria and Searching Main Form
    By gatorator in forum Access Tables & Databases
    Replies: 3
    Last Post: 04-06-2011, 07:48 AM
  4. to make a certain Excel sheet visible/hidden, based on the value of a cell.
    By unique_loy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-12-2011, 11:50 AM
  5. Help to make a single picture visible when all pictures are set to be hidden
    By Gowen in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-03-2010, 03:45 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