Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Write in the spreadsheet having a form open
Hi everybody, How can I write in the spreadsheet having a form open? I can not us the ShowModal property. Thanks in advance. Lidma -- lidma ----------------------------------------------------------------------- lidmat's Profile: http://www.excelforum.com/member.php...fo&userid=1665 View this thread: http://www.excelforum.com/showthread.php?threadid=31927 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Write in the spreadsheet having a form open
"lidmat" skrev i melding
... How can I write in the spreadsheet having a form open? I can not use the ShowModal property. Hi Lidmat. You're out of luck then. Why can't you use the modal property ? HTH. Best wishes Harald |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Write in the spreadsheet having a form open
Hi Harald!!! If I put the ShowModal property to False the form doesn’t stay on th screen, it continues with the next line of code, for example: I have two forms the first one has a button that calls the second one which has the ShowModal property equal to False and has another butto to come back to the first form, when a form is open it stays on th screen until you do something but in this case not it comes back to th procedure where it was called and continue with the next line. --I open the first form and I press the button that calls the secon one Private Sub Introducedatamanually_Click() UserForm1.Hide UserForm2.Show //it jumps to the next line without waiting for th instruction MsgBox ("Hello") //to come back that is written in the second use form Unload UserForm2 End Sub --After enter the date I want to coma back to the first form Private Sub Comeback_Click() Unload Me UserForm1.Show End Sub Thanks Lidma -- lidma ----------------------------------------------------------------------- lidmat's Profile: http://www.excelforum.com/member.php...fo&userid=1665 View this thread: http://www.excelforum.com/showthread.php?threadid=31927 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Write in the spreadsheet having a form open
"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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |