View Full Version : VBA UserForms
aussieolie2
11-14-2002, 10:59 AM
Does Anybody know how I can get a custom UserForm to display (either in a module/script) without having to press the play button in VBA.
This is for VBA in Powerpoint.
Anybody know of any good VBA forums?
Thanks
Olie
Hi,
If you are wanting to call the form in a module it is a simply a case of entering the form name and the words "show", see below.
Public Sub showform()
UserForm1.Show
End Sub
If you delcare it as a public sub it will also appear in the macro's list in powerpoint.
As regards a VBA forum, I have been using a dicussion forum http://www.visualbasicforum.com which covers both VBA and visual basic. I have found it to be a great help becaase it always has around 20 members online, which gives you a quick response time.
Hope this help.
Slim
aussieolie2
11-16-2002, 01:37 PM
Thanks Man,
It works!! Thanks.
vBulletin v3.6.1, Copyright ©2000-2009, Jelsoft Enterprises Ltd.