Creating forms using visual basic programming

I notice that MS Office programs like Powerpoint, ACCESS, and WORD have in their menu's a place to build visual basic.  How do you make this work when you build forms?  Is the visual basic form you design dependent/independent from the application you made it in (i.e. ACCESS, PPT, WORD, etc).

Let's keep it simple. say I just want to create a user friendly menu screen that I can click on its buttons to open a particular file on my computer much like the same way you do in an html link from the web.  Do I need a special software program to create this?  Is it an EXE file when I finish or how does the form open?  I would like to make this FORM INDEPENDENT from the application/file it will eventually open.

I appreciate any comments you have.
Who is Participating?
Arthur_WoodConnect With a Mentor Commented:
If you design a form in an Office application (PowerPoint, Excel, Word, Access) THAT form is Specific to that office product (and is in fact called a UserForm).  These forms ARE NOT directly exportable to an independent Visual Basic 6 stand-alone program.  

As to the second part of your question, it appears that you are asking about a general purpose program, which would be written in Visual Basic and NOT using one of the Office Suite.  In order to create a stand-alone EXE, you would use VB6 (if you have it - Microsoft is no longer selling Visual Basic 6, it has recently been "upgraded" to a New version known as VB.NET - part of Visual Studio.NET) or VB.NET.

Arthur Wood

Do you mean vb (ide) or a vba (office) ??
Do you mean vb (ide) or vba (office) ??
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Richie_SimonettiIT OperationsCommented:
You can create them from either with Visual Basic program or with office VBA.
If you need a stand-alone app (like worpad or paint, etc) you need to create it with VB.
If you need a solution that involves Office, you could use VBA from any of Office applications.
Hope it clarify something.
jayme9Author Commented:
EXACTLY and simply answered my question.  Thanks.

I will plan to purchase VB6 or stand-alone visual basic software program which seems to be the most flexible option for creating an idependent userform.
Richie_SimonettiIT OperationsCommented:
Nice! :(
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.