Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBProj.VBComponents
Using http://www.cpearson.com/excel/vbe.aspx
The line Set VBComp = VBProj.VBComponents(module) expects a module name such as "sheet1" or "sheet2", which is nice if you know which sheet it is. Can we reference the VBComponents by the sheet name instead? Such as for sheet2(MySheet) I want to use MySheet, since it is not always sheet2. Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBProj.VBComponents
Set VBComp = VBProj.VBComponents(worksheets("Somesheetnamehere" ).codename)
or Set CodeMod _ = VBProj.VBComponents(worksheets("Somesheetnamehere" ).codename).codemodule Tim Rush wrote: Using http://www.cpearson.com/excel/vbe.aspx The line Set VBComp = VBProj.VBComponents(module) expects a module name such as "sheet1" or "sheet2", which is nice if you know which sheet it is. Can we reference the VBComponents by the sheet name instead? Such as for sheet2(MySheet) I want to use MySheet, since it is not always sheet2. Thanks! -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBProj.VBComponents
Thanks! Not at work at the moment, but when I get in tomorrow will
definitely use it. It makes sense now that I see it. "Dave Peterson" wrote: Set VBComp = VBProj.VBComponents(worksheets("Somesheetnamehere" ).codename) or Set CodeMod _ = VBProj.VBComponents(worksheets("Somesheetnamehere" ).codename).codemodule Tim Rush wrote: Using http://www.cpearson.com/excel/vbe.aspx The line Set VBComp = VBProj.VBComponents(module) expects a module name such as "sheet1" or "sheet2", which is nice if you know which sheet it is. Can we reference the VBComponents by the sheet name instead? Such as for sheet2(MySheet) I want to use MySheet, since it is not always sheet2. Thanks! -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBProj.VBComponents
Yep, that did it for me. Thanks!!!
I just posted another question using this routine, but its not related to this one so thought a new thread would be better. "Dave Peterson" wrote: Set VBComp = VBProj.VBComponents(worksheets("Somesheetnamehere" ).codename) or Set CodeMod _ = VBProj.VBComponents(worksheets("Somesheetnamehere" ).codename).codemodule Tim Rush wrote: Using http://www.cpearson.com/excel/vbe.aspx The line Set VBComp = VBProj.VBComponents(module) expects a module name such as "sheet1" or "sheet2", which is nice if you know which sheet it is. Can we reference the VBComponents by the sheet name instead? Such as for sheet2(MySheet) I want to use MySheet, since it is not always sheet2. Thanks! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Security and working with VBComponents | Excel Programming | |||
VBComponents question | Excel Programming | |||
Links between VBComponents and Sheets 3 | Excel Programming | |||
Links between VBComponents and Sheets 2 | Excel Programming | |||
Links between VBcomponents and Sheets | Excel Programming |