| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to show to a form in excel vba?
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to show to a form in excel vba?
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 -- Regards, Sébastien "Grd" wrote: 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to show to a form in excel vba?
That worked for me
Thanks Grd "sebastienm" wrote: 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 -- Regards, Sébastien "Grd" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In Excel how do I show the contents of just 1 row as a form? | Excel Discussion (Misc queries) | |||
| Show Data Form | Excel Programming | |||
| Help! Animated gif-image in form does not show animation when form loaded | Excel Programming | |||
| form wont show? | Excel Programming | |||
| Show user form | Excel Programming | |||
Linear Mode
