+ Reply to Thread
Results 1 to 3 of 3

Open a userform from a userform, but preserve the info in the original userform

  1. #1
    Forum Contributor
    Join Date
    08-16-2010
    Location
    Holland, MI
    MS-Off Ver
    Excel 2007
    Posts
    110

    Open a userform from a userform, but preserve the info in the original userform

    Hi all,
    I'm using a Userform that requires the user to enter a bunch of information. In one of the textboxes, they must enter a certain code that they may or may not know. If they don't know the code they should be using, I want to set it so a new userform appears that gives them the options to select (It's a hierarchy type code selection process where each level selected give them a new set of items to select, kinda like ebay when you're selecting the category for a listing). So, the new userform that is opened will have 3 listboxes in it that I populate based on the selection in the previous list box. I'm all set there. But, what I need help with is how to open and use that new listbox without losing all of the information in the previous Userform. Can I keep the original Userform open and just open the new one if front of it? Or, can the original Userform just be pushed into the background while the user is making the selections? Then when the selection is made, the original userform comes back up will all the information already in it. Is this possible?

    thanks for the help!

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Open a userform from a userform, but preserve the info in the original userform

    You can opent the second userform on top of the first.

    If you wanted you could hide the first as well but it might be better to keep it in view so the user can refer to it if they need to.
    If posting code please use code tags, see here.

  3. #3
    Forum Contributor
    Join Date
    08-16-2010
    Location
    Holland, MI
    MS-Off Ver
    Excel 2007
    Posts
    110

    Re: Open a userform from a userform, but preserve the info in the original userform

    Thanks for the reply Norie. Yeah, I kinda stumbled on a way to do it using userform.hide and userform.show. thanks for the input.

+ 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