Excel vba VBE window

[RICHIEG]

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

 

[NoSparks]

Windows Key plus left or right arrow key

 

[RICHIEG]

Thanks will try that much appreciated

 

[montecarlo2012]

check this

 

[RICHIEG]

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]

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.