Hello,
I'm new to User Forms and am working on a simple UserForm that I would like to be able to close via code and not by command button or the title bar "X". Eventually I plan on hiding the UF title bar and not have any buttons on it. I've scoured the net and tried many ways with no success except in the Activate Event such as:
However, I do not want to use the activate event or a click event (button) to close it, is there another way?Private Sub UserForm_Activate() Application.Wait Now + TimeValue("00:00:02") Unload Me End Sub
Thx
Gary