UserForm Question
I am having trouble with a userform that opens sometimes and gives an error other times. How do I code displaying and then unloading a userform? I have tried UserForm.Show vbModeless (this works) but when I close UserForm.Hid and try to reopen (UserForm.Show vbModeless) I get a error. Please help. Thanks -- bforster ----------------------------------------------------------------------- bforster1's Profile: http://www.excelforum.com/member.php...fo&userid=1177 View this thread: http://www.excelforum.com/showthread.php?threadid=27588 |
UserForm Question
Hi bforster1
Unload UserForm1 Read this KB http://support.microsoft.com/default...b;EN-US;829070 -- Regards Ron de Bruin http://www.rondebruin.nl "bforster1" wrote in message ... I am having trouble with a userform that opens sometimes and gives and error other times. How do I code displaying and then unloading a userform? I have tried UserForm.Show vbModeless (this works) but when I close UserForm.Hide and try to reopen (UserForm.Show vbModeless) I get a error. Please help. Thanks. -- bforster1 ------------------------------------------------------------------------ bforster1's Profile: http://www.excelforum.com/member.php...o&userid=11771 View this thread: http://www.excelforum.com/showthread...hreadid=275882 |
All times are GMT +1. The time now is 01:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com