Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
need to minimize userform via command button on itself
hi - I'm building a simple data entry user form with a command button
at the bottom of it. When i click on this button, I'd like : a) the user form to minimize (not hide. see below) b) go to a specific worksheet in the workbook. I have the part b) down with the simple Sheets("xxxx").Select command. no problem there. but I'm having a difficult time finding information about how to do a). I tried userform1.hide command but when I try to show the userform again by creating a button on the worksheet and linking it to userform1.show, all the information that were entered previously are all gone so that solution didn't work. if you know how to hide without having the previously entered data wiped out, that solution would be a good alternate solution. I do have the minimize/maximize button all setup from other threads. but in addition to those, i want this other particular command button on the user form to trigger the minimizing of itself Thanks for your help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
need to minimize userform via command button on itself
Hide doesn't remove the previous data in my experience. You must be doing
something special. A: unloading instead of hiding B: showing a different copy of the useform C: set your links up so they pick up from the activesheet -- Regards, Tom Ogilvy "Jed" wrote: hi - I'm building a simple data entry user form with a command button at the bottom of it. When i click on this button, I'd like : a) the user form to minimize (not hide. see below) b) go to a specific worksheet in the workbook. I have the part b) down with the simple Sheets("xxxx").Select command. no problem there. but I'm having a difficult time finding information about how to do a). I tried userform1.hide command but when I try to show the userform again by creating a button on the worksheet and linking it to userform1.show, all the information that were entered previously are all gone so that solution didn't work. if you know how to hide without having the previously entered data wiped out, that solution would be a good alternate solution. I do have the minimize/maximize button all setup from other threads. but in addition to those, i want this other particular command button on the user form to trigger the minimizing of itself Thanks for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Minimize button on userform? | Excel Discussion (Misc queries) | |||
Specifying a Command Button on a worksheet as differentiated from one on a UserForm | Excel Programming | |||
Userform disappears when you try to initialize from a command button | Excel Programming | |||
VBA userform with minimize button | Excel Programming | |||
COM add-in userform minimize button | Excel Programming |