I just created a form that displays when the workbook opens... Userform1.show vbmodeless.
Basically, the userform contains a textbox which informs the user that something else is being done. The problem with this is just a blank Userform with no textbox appears. Now, if I just use 'Userform1.show' (without vbmodeless) it works. But thats not what I want. What is going on and how can I show the Userform (with the message) as modeless?
Basically, the userform contains a textbox which informs the user that something else is being done. The problem with this is just a blank Userform with no textbox appears. Now, if I just use 'Userform1.show' (without vbmodeless) it works. But thats not what I want. What is going on and how can I show the Userform (with the message) as modeless?