Handle worksheet with userform loaded (excel vba)?

Navigation
4

When we have userform loaded, can you change / browse in spreadsheets of excel ?

    
asked by anonymous 22.03.2017 / 23:47

2 answers

2

Yes, it is possible.

Check the% coop% property of Userform as ShowModal , or change this property via VBA when you want ( False ).

This allows you to manipulate the worksheet while the Userform is open, although it still remains as the top window.

    
23.03.2017 / 14:27
4

Yes! Set the ShowModal property to false .

    
23.03.2017 / 14:26
Regular expression for password Using Concat to concatenate array of strings