+ Reply to Thread
Results 1 to 3 of 3

Initialized Form Life

  1. #1
    Registered User
    Join Date
    05-22-2008
    Posts
    74

    Initialized Form Life

    Once a form is initialized is it initialized until the application ends? When you hide a form it doesn't clear so I assume it stays alive and is just hidden. I want to collect data from a worksheet and display it in the form that was used to originally gather the info. So working with the select row I just gather the info and assign it to the fields in the form. What kind of traps can I avoid?

    Edit: I found one problem I need help with. When I run the form originally the OK runs a routine that places all the data on the worksheet. This, of course fires the selectionchange of the worksheet which is the routine that I am using to read the data into the form. How do I tell the worksheet to ignore the selection change when it is info being added?
    Last edited by scottintexas; 06-21-2008 at 10:02 AM.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,480
    Hi,
    If you hide a userform, the information remains as you have mentioned.
    unloading a userform will clear the information.

    What kind of controls to populate are you using in the userform

  3. #3
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    i think you need to give some more information on what you are attempting.
    Hope that helps.

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

    Free DataBaseForm example

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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