Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 36
Default Immediate Window - Available Commands

Has anyone compiled a list of the commands that can be used in the Immediate
Window? I have learned so much by seeing the contributors illustrate the
effects of certain commands this way. And when I needed to delete an object
but didn't know how to refer to it, I googled "immediate window selection"
and found I could identify it using ? typename(selection) & ?
selection.name.

It would be nice to know what commands are available so that I could really
explore the object model. I know you can use F1 and F2 in the VBE, but they
aren't as helpful to the inexperienced programmer (not to me anyway).

Thanks in advance!

Patti


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Immediate Window - Available Commands

Perhaps I misunderstand you question or your intent, but I would proceed
with the thought that there are no commands that you can't use in the
immediate window except the DIM command or some other declarative command.


If you can't use it, it will tell you, but I am hard pressed to think of any
off the top of my head, especially if you are examining the object model.
If you run into such, put it in a function in a module and call it from the
immediate window.

--
Regards,
Tom Ogilvy




"Patti" wrote in message
...
Has anyone compiled a list of the commands that can be used in the

Immediate
Window? I have learned so much by seeing the contributors illustrate the
effects of certain commands this way. And when I needed to delete an

object
but didn't know how to refer to it, I googled "immediate window selection"
and found I could identify it using ? typename(selection) & ?
selection.name.

It would be nice to know what commands are available so that I could

really
explore the object model. I know you can use F1 and F2 in the VBE, but

they
aren't as helpful to the inexperienced programmer (not to me anyway).

Thanks in advance!

Patti




  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 400
Default Immediate Window - Available Commands

OPTION & DIM is the only command that I have been able to use, regardless.
All other 'statements' that can used, some of them would require you to be in
'suspension' i.e. be in trace mode (F8).

"Tom Ogilvy" wrote:

Perhaps I misunderstand you question or your intent, but I would proceed
with the thought that there are no commands that you can't use in the
immediate window except the DIM command or some other declarative command.


If you can't use it, it will tell you, but I am hard pressed to think of any
off the top of my head, especially if you are examining the object model.
If you run into such, put it in a function in a module and call it from the
immediate window.

--
Regards,
Tom Ogilvy




"Patti" wrote in message
...
Has anyone compiled a list of the commands that can be used in the

Immediate
Window? I have learned so much by seeing the contributors illustrate the
effects of certain commands this way. And when I needed to delete an

object
but didn't know how to refer to it, I googled "immediate window selection"
and found I could identify it using ? typename(selection) & ?
selection.name.

It would be nice to know what commands are available so that I could

really
explore the object model. I know you can use F1 and F2 in the VBE, but

they
aren't as helpful to the inexperienced programmer (not to me anyway).

Thanks in advance!

Patti





  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 400
Default Immediate Window - Available Commands

.... should have said "unable to use"
(DECLARE is also not available).

"AA2e72E" wrote:

OPTION & DIM is the only command that I have been able to use, regardless.
All other 'statements' that can used, some of them would require you to be in
'suspension' i.e. be in trace mode (F8).

"Tom Ogilvy" wrote:

Perhaps I misunderstand you question or your intent, but I would proceed
with the thought that there are no commands that you can't use in the
immediate window except the DIM command or some other declarative command.


If you can't use it, it will tell you, but I am hard pressed to think of any
off the top of my head, especially if you are examining the object model.
If you run into such, put it in a function in a module and call it from the
immediate window.

--
Regards,
Tom Ogilvy




"Patti" wrote in message
...
Has anyone compiled a list of the commands that can be used in the

Immediate
Window? I have learned so much by seeing the contributors illustrate the
effects of certain commands this way. And when I needed to delete an

object
but didn't know how to refer to it, I googled "immediate window selection"
and found I could identify it using ? typename(selection) & ?
selection.name.

It would be nice to know what commands are available so that I could

really
explore the object model. I know you can use F1 and F2 in the VBE, but

they
aren't as helpful to the inexperienced programmer (not to me anyway).

Thanks in advance!

Patti





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to save a desired window size but hv window comeup fullsz by d smjm1982 Excel Discussion (Misc queries) 1 February 15th 08 11:10 AM
View cell contents as a pop-up window (similar to comments window) Oldersox Excel Worksheet Functions 1 February 6th 08 07:09 AM
Docking Project Explorer, Properties window and Code window in VBE jayray Setting up and Configuration of Excel 2 March 27th 07 04:42 PM
The window opens in a smaller window not full sized window. Rachael Excel Discussion (Misc queries) 0 November 7th 06 09:04 PM
Issue Commands To a DOS Window Andibevan[_2_] Excel Programming 4 June 13th 05 04:23 PM


All times are GMT +1. The time now is 11:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"