Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Keeping VB Window on Screen
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Keeping VB Window on Screen
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Keeping VB Window on Screen
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Keeping VB Window on Screen
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Keeping VB Window on Screen
Thanks everyone. You're correct in that what I'm trying to do is keep both
screens up so when I work in the Excel file, I can still see the VB window. I can work in VB and still see the Excel file, but not the other way around. "Peter T" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keeping Rows on the screen? | New Users to Excel | |||
How do you block the copy window to right of screen | Excel Discussion (Misc queries) | |||
How can help window be moved on screen? | Excel Discussion (Misc queries) | |||
Position Form on screen v Window Zoom ! | Excel Programming | |||
Keeping Excel Hyperlinks From Launching More Than One Browser Window | Excel Programming |