ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Automatically close a userform (https://www.excelbanter.com/excel-programming/312231-automatically-close-userform.html)

ForSale[_54_]

Automatically close a userform
 

Thanks,
That tells me invalid outside procedure and highlights the word "Now".
Any thoughts

--
ForSal
-----------------------------------------------------------------------
ForSale's Profile: http://www.excelforum.com/member.php...fo&userid=1189
View this thread: http://www.excelforum.com/showthread.php?threadid=26566


Norman Jones

Automatically close a userform
 
Hi ForSale,

Try changing:

Private UserForm_Activate()

to:

Private Sub UserForm_Activate()

---
Regards,
Norman



"ForSale" wrote in message
...

Thanks,
That tells me invalid outside procedure and highlights the word "Now".
Any thoughts?


--
ForSale
------------------------------------------------------------------------
ForSale's Profile:
http://www.excelforum.com/member.php...o&userid=11896
View this thread: http://www.excelforum.com/showthread...hreadid=265660





All times are GMT +1. The time now is 02:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com