I need to use a userform to pause my code from running but I need to beable to change things on the spreadsheet while the code is up.Load formForm.show 0Does not work. Any ideas?
Make thge form modeless, (ShowModal property set to False - preferablyat design time rather than at runtime).
can u try withform.hideit will hide the current form, and it ll allow to edit the cells, then againyou have to try withform.show