MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Userforms to stop data

  Asked By: Ted    Date: Mar 07    Category: MS Office    Views: 1764

I need to use a userform to pause my code from running but I need to be
able to change things on the spreadsheet while the code is up.

Load form
Form.show 0

Does not work. Any ideas?



2 Answers Found

Answer #1    Answered By: Aberto Rossi     Answered On: Mar 07

Make thge form modeless, (ShowModal property set to False - preferably
at design time rather than at runtime).

Answer #2    Answered By: Nina Garcia     Answered On: Mar 07

can u try with


it will hide the current form, and it ll allow to edit the cells, then again
you have to try with


Didn't find what you were looking for? Find more on Userforms to stop data Or get search suggestion and latest updates.