Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
.... 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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to save a desired window size but hv window comeup fullsz by d | Excel Discussion (Misc queries) | |||
View cell contents as a pop-up window (similar to comments window) | Excel Worksheet Functions | |||
Docking Project Explorer, Properties window and Code window in VBE | Setting up and Configuration of Excel | |||
The window opens in a smaller window not full sized window. | Excel Discussion (Misc queries) | |||
Issue Commands To a DOS Window | Excel Programming |