VBE - code duplication concern...

[Steve P]

Hello everyone,

I have successfully writen a data import script that appends excel data to
an exisiting table. I wrote the script to operate on the button-click event
for a command button. When navigating my code in the VBE, I notice that the
code is duplicated in different form objects, which it shouldn't be. I would
like to only view the vba code that corresponds to the form I am working
with, or intend to be working with.

Is there a view-setting in the VBE that will accomplish this?

 

[pietlinden]

Hello everyone,

I have successfully writen a data import script that appends excel data to
an exisiting table. I wrote the script to operate on the button-click event
for a command button. When navigating my code in the VBE, I notice that the
code is duplicated in different form objects, which it shouldn't be. I would
like to only view the vba code that corresponds to the form I am working
with, or intend to be working with.

Is there a view-setting in the VBE that will accomplish this?

Doesn't sound like a view-setting problem. Sounds like a coding
issue..

If you reuse the exact same chunk of code over and over, why not just
take the whole thing, put it in it's own function/sub and then include
arguments so you can call it from anywhere?

 

[Klatuu]

The only options are for the current module or the current procedure. You
can only see other modules by changing windows in the VBA editor. I don't
really know what it is you think you are seeing.

 

[Steve P]

I like that idea better. How do you call a public sub from a command button
click?