Current location - Quotes Website - Signature design - When VBA runs until the first window pops up, you can only use the keyboard to enter the table area, but not the mouse box to select it. How to change it? I am EXCEL2007.
When VBA runs until the first window pops up, you can only use the keyboard to enter the table area, but not the mouse box to select it. How to change it? I am EXCEL2007.
You just can't see the area you choose. Actually, you can choose.

You apply. Screenupdating = false to the next line of inputbox.

Or take it off. This is to stop the screen update.