Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

vba code template

Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » VBA code as a template

VBA code as a template

ResolvedVersion 2003

Kiran has attended:
Excel Advanced course
Excel VBA Intro Intermediate course

VBA code as a template

Is it possible to create a code and save it as a template to be called into any other spreadsheet (with the core essential fixes fields, ofcourse, that will apply to all or most of spreadsheets). if so, how to do it?

Regards

Kiran

RE: VBA code as a template

Hi Kieran

Thanks for your question

I am assuming you want the code to be available to any workbook you open. The best solution would be to write your code in the personal macro workbook, which you can access through VBA's project explorer.
This will then be available to all workbooks open on your machine

Regards

Stephen


Tue 9 Mar 2010: Automatically marked as resolved.

 

Training courses

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Access tip:

Insert The Current Time

To insert the current time into a Table field or Form textbox use:

Ctrl+Colon(:)

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.