PDA

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

slim
11-16-2002, 11:25 AM
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.