![]() |
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 |
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 |
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 |
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