Handle spreadsheet with userform loaded (excel vba)?

Asked

Viewed 4,543 times

5

When we’re with a userform loaded, it is possible alter/navigate in the spreadsheets of excel?

excel vba

2 answers

4

2


Yes, it is possible.

Mark the property ShowModal userform as False, or change this property via VBA when you want (Me.ShowModal = False).

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

Browser other questions tagged excel vba

You are not signed in. Login or sign up in order to post.