View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Keeping VB Window on Screen

Hi Norman,

I interpreted the OP's question same as you, and could not have added to
your answer.

My little "FWIW" was a small related tip the OP might have found useful if
he did not already know it.

Regards,
Peter

"Norman Jones" wrote in message
...
Hi Peter,

I cannot figure out how to keep both the Excel spreadsheet
and VB window on the screen at the same time;


I interpreted the OP literally and assumed that, perhaps, he wanted to see
the results of code actions whilst stepping through the code.

---
Regards,
Norman


"Peter T" <peter_t@discussions wrote in message
...
Also FWIW,

Alt-F11 to toggle Excel / VBE windows

Regards,
Peter T

"Norman Jones" wrote in message
...
Hi Paige,

Reduce the size of the Excel window so that it covers, say, half of the
screen. Then arrange the Excel and VBE windows.

---
Regards,
Norman



"Paige" wrote in message
...
Am sure this is a really stupid question, but I cannot figure out how
to
keep
both the Excel spreadsheet and VB window on the screen at the same
time;
whenever I have them both up and select a cell on the Excel
spreadsheet,
my
VB window disappears. I'm using Excel 2002. Thanks.....pc