Spreadsheet focus/interaction whilst VBA form is active

[carcharoth2554]

Hi All,

Excel 2010 Win 64

I have wookbook with multiple worksheets within that all contain large grids of data that flow over the size of the window. I have made some code that selects a cell based on user input into a form and drops new data into it. I was wondering if there was any code that will pan the worksheet to look at that cell when the user makes a selection? This led me to question if there was a way to unlock the spreadsheet when a vba form is open so that you can at a minimum navigate the current worksheet. Unfortunately this is quite hard to search up on google.

Again, any input is appreciated.

Thanks!

 

[Firefly2012]

Hi

When you display a userform (using Show) you need to show it modelessly:

UserForm1.Show vbModeless

 

[carcharoth2554]

Great Scott!!!

Why had I not thought of asking this sooner?

Now I am all powerful!!!

 

[carcharoth2554]

Thank you for the help!

 

[Firefly2012]

You're welcome