How to show to a form in excel vba?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I need to show a form on the screen that I have created in excel vba. The
form is called SalesForm1.

What lines of code do I need? I can't seem to figure it out.

Any help appreciated.

Thanks in advance

Grd
 
Hi,
Try
SalesForm1.Show
from a macro and run that macro.
If in xl 2k or above you decide to show the form in modal or modeless mode.
SalesForm1.Show vbModal '<-- default
SalesForm1.Show vbModeless
 
That worked for me

Thanks

Grd

sebastienm said:
Hi,
Try
SalesForm1.Show
from a macro and run that macro.
If in xl 2k or above you decide to show the form in modal or modeless mode.
SalesForm1.Show vbModal '<-- default
SalesForm1.Show vbModeless
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA - Problem with Closing Print Preview 0
Trouble Installing Excel VBA Code Cleaner into Office 365 0
Excel/VBA Coding Help 4
what is stdole reference in excel vba library 1
How open notepad.exe and write text line by line via excel vba? 2
Excel VBA 0
Excel VBA in Citrix. 0
Help with copying a sheet from One workbook to another workbook 1

Back
Top