I want my user to be able to check some boxes in a UserForm AND to edit some data in his sheet before the code continues.
According to the Show Form help "When a UserForm is modeless, subsequent code is executed as it's encountered." So, if I use a modeless form the code continues running without waiting for the user's input.
As far as I can see, the only way around this is to put "UserForm.Show vbModeless" as the last line in one macro and trigger the continuing code in a second macro from the form's own Private Sub cmdOK_click().
Is that right, please?
tia
According to the Show Form help "When a UserForm is modeless, subsequent code is executed as it's encountered." So, if I use a modeless form the code continues running without waiting for the user's input.
As far as I can see, the only way around this is to put "UserForm.Show vbModeless" as the last line in one macro and trigger the continuing code in a second macro from the form's own Private Sub cmdOK_click().
Is that right, please?
tia