Hello Guys,
I have created a "UserForm 1". It contains texboxes and their buttons. When I click the button I want an "userform 2" to pop up and textboxes should be created in it.
For example. In "UserForm 1" , I have a text box . If I enter a value = "5" and click the button, I want another "UserForm 2 " to pop up and "5" text boxes should be created in UserForm 2.
Looking forward for your help.
Thanks in Advance
AdiK,
How you do this depends greatly on the needs. Will UserForm2 ONLY be invoked by UserForm1? Should UserForm1 go away when UserForm2 loads?
Assuming yes to those questions:
The button for userform1 would only need one line:
then in userform2:
Please Login or Register to view this content.
In userform1 you may want to add some kind of check that there really is a number in Textbox1 before calling up UserForm2Please Login or Register to view this content.
Last edited by Arkadi; 02-09-2017 at 09:25 AM.
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
You will also have to set the VISIBLE property...
of the textboxes? They are visible by default
My apologies. Other controls (labels, for example) are invisible by default. I just tend to set the Visible property as a matter of course.
No worries cytop, it is good practice either way, I should do that.
I have edited my post to include the suggestion.
Thaks a lott guys..
But the "Userform 1" is still visible after "UserForm 2" is opened. I have used Unload Me command but it doesnt work.
In the Initialize for form2, did you include the line I had to unload userform1? name must match exactly for it to work of course.... but it works on my end. Userform1 can't unload itself while form2 is up unless form2 is modeless...
Got it!! Thank u very much again!
Great!
If you are happy with the result, please remember to mark the thread as solved?
I have a problem Arkadi. In the "UserForm 2 ", I have a frame and a multipage setup. When i run the code by clicking the button on "Use form 1", the text box gets created on the "UserForm 2", but hides behind the frame and the multipage. How can i send the frame ad the multipage behind the text box??
I have a problem Arkadi. In the "UserForm 2 ", I have a frame and a multipage setup. When i run the code by clicking the button on "Use form 1", the text box gets created on the "UserForm 2", but hides behind the frame and the multipage. How can i send the frame ad the multipage behind the text box??
I think what you want then is to put the texboxes in the frame, not the basic form?
Change:
toPlease Login or Register to view this content.
Where Frame1 is the name of the frame you are referring to.Please Login or Register to view this content.
This works Fine. But there is still the Multipage ( Page 1 and Page 2) over the Frame and Similar line of code is not available for multipages.
Oh the frame is behind the multipage?
Try this:
Pages(0) is the first page, change as needed... and MultiPage1 should match the name of your multipage:
Please Login or Register to view this content.
Thanks a ton!!
For me mostly experience now... but when I was learning (and still often need to remember exact syntax), I used google, often 1 hour of google for 15 minutes of code.
It gets easier as you practice and learn of course.
Please remember to mark the thread as solved if your issue is resolved? Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks