Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
"lidmat" skrev i melding
... Hi Harald!!! If I put the ShowModal property to False the form doesn't stay on the screen, it continues with the next line of code, for example: Gotcha. Well, the "next line" of code should not be below in a long list of chronological order, but a separate form2 sub ran when something on form 2 happens and is validated OK. This is not easy, but instead of a long list of happenings, you need several small userform procedures telling the next form what to do and maybe also passing along what has been done already. Apologies for being so general. But you're almost there, so give it another try. Best wishes Harald |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Write record from Form to new row in spreadsheet | Excel Discussion (Misc queries) | |||
Write record from Form to new row in spreadsheet | Excel Discussion (Misc queries) | |||
Using a template form, advance a form number everytime you open | Excel Discussion (Misc queries) | |||
is it possible to execute write to the fields in another .xsl form a macro in another .xsl? e.g. some way to load another .xsl into an .xsl macro and write to its data? | Excel Worksheet Functions | |||
Is it possible to open the VBA form with a link in a sheet and to pass variable from a cell to the VBA form? | Excel Programming |