Excel vba VBE window

RICHIEG

New Member
Joined
Sep 6, 2020
Messages
3
Office Version
  1. 365
Platform
  1. Windows
I can't adjust the size of the main VBE window. It is either fully maximized or minimized. I wish to be able to view what is happening in excel at the same my code in the VBE is running to see the results as I step through my code. Due to this problem I can only see the worksheet or the VBE and not both at the same time. Any help would be appreciated. thanks
 

Some videos you may like

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

NoSparks

Well-known Member
Joined
Mar 15, 2013
Messages
1,021
Office Version
  1. 2010
Platform
  1. Windows
Windows Key plus left or right arrow key
 

RICHIEG

New Member
Joined
Sep 6, 2020
Messages
3
Office Version
  1. 365
Platform
  1. Windows
Thanks will try that much appreciated
 

RICHIEG

New Member
Joined
Sep 6, 2020
Messages
3
Office Version
  1. 365
Platform
  1. Windows
Its not the excel window that's the issue, its the VBE window that won't resize. Its either fully maximized or minimised. The restore button which is middle of 3 buttons in top right corner of any window is not working. O can't therefore alter size if VBE window. I need to see the VBE window and excel at the same time
 

NoSparks

Well-known Member
Joined
Mar 15, 2013
Messages
1,021
Office Version
  1. 2010
Platform
  1. Windows
Have you somehow disabled the built-in Windows Snap feature ?
Have a look at the video on this page, and let Windows put the Excel Sheet on one half your screen and the VBE window on the other half. I do it all the time with the Windows logo key and the Arrow keys.
 

Watch MrExcel Video

Forum statistics

Threads
1,119,188
Messages
5,576,590
Members
412,736
Latest member
LODS
Top