View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Immediate Window Can't Be Viewed

Just a guess...

Maybe the immediate window is just off the screen.

When I open the VBE and hit ctrl-g, the immediate window becomes the active
window--even if I can't see it.

Can you try opening the VBE, hit ctrl-g and (be careful) type:
msgbox 1234
(and hit enter)

Do you see the message box pop up?

If yes, then I think the immediate window is just off the screen.

With the immediate window still active (don't click out of it!), try this:
alt-spacebar
m

(This is the shortcut for choosing Move option on the title bar of the
activewindow.)

Now you can use the cursor keys to try to get the immediate window back in view
-- so you can dock it where you want.

(Move it left, right, up, down, .... until you see it <vbg.)

=========
If this fails, you can try this technique that I've saved from a previous post:

When I screw up the layout (including the tiling), I'll just follow these
instructions from Tom Ogilvy:

What version of excel? If Version 2002 or 2003 look for

HKEY_CURRENT_USER\Software\Microsoft\VBA\6.0\Commo n\Dock

you aren't deleting a file. You are deleting a value in the registry.
Windows/Excel will recreate it with default values which should restore the
original layout of the VBE.



Rich Locus wrote:

Hello Microsoft Community:

For whatever reason, my Immediate Window in Office 2002 will not show. I
have tried CTRL-G and View Immediate but the immediate window does not show
for either Access or Excel.

Any ideas? It must be system-wide because it affects both Access and Excel.
--
Rich Locus
Logicwurks, LLC


--

Dave Peterson