Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Getting input object from separate VBA module

Getting input object from separate VBA module

Getting input object from separate VBA module

Hi everyone,

I have a bit of a VBA rookie question.

I am able to do long VBA programs, with single inputs, multiple inputs, loops, etc etc.

But I'd like to start cleaning up my code, and avoid doing multiple copy/paste everytime to get my code running.

So, question:

How to I call and use inputs from external macros?

For example, say I have a code that uses one axisSystem, and multiple surfaces.

How to I call an external module and use the axisSystem collected, and from another module use the collection of surfaces in a loop for example?

Thanks in advance!

RE: Getting input object from separate VBA module

Hi, i work in Visual Basic, all code is on one place.
For start you need to write some methods, i don't know do you use them.
From other side you can have one main array for ex. for axis systems, and you can use it in all of your macros.
So when you make selection it will be stored in that main array, and you can use it in every macro you want.
Ofc you can have more of those arrays for different stuff.

I have one huge Visual Basic macro app and i use this approach. I don't know structure of your code, so i don't know can you go like this.

It will be good option if you move to Visual Basic its relay cool and easy. (visual studio is free to use)

you can check this post for example https://catiavbmacro.com/2018/11/17/lego-catia-mac...

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


eBook - Efficient and Effective Production Support with 3D Printed Jigs and Fixtures
Jigs and fixtures offer manufacturers a reliable process for delivering accurate, high-quality outcomes, whether for a specific part or feature, or for consistency across multiples of parts. Although the methodologies and materials for producing jigs and fixtures have evolved beyond the conventional metal tooling of years past, their position as a manufacturing staple remains constant due to the benefits they offer. Download Now
Overcoming Cutting Tool Challenges in Aerospace Machining
Aerospace manufacturing has always been on the cutting edge, from materials to production techniques. However, these two aspects of aerospace machining can conflict, as manufacturers strive to maintain machining efficiency with new materials by using new methods and cutting tools. Download Now

Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close