ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Immediate Window - Available Commands (https://www.excelbanter.com/excel-programming/360163-immediate-window-available-commands.html)

Patti[_2_]

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



Tom Ogilvy

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





AA2e72E

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






AA2e72E

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







All times are GMT +1. The time now is 12:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com