VBA code as a template

Resolved · Low Priority · Version 2003

Sun 28 Feb 2010, 13:36 Delegate Kiran said...

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

Wed 3 Mar 2010, 09:39 Trainer Stephen said...

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

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Access tip:

Open A Combo Box Automatically

This is helpful if users need to enter large amounts of data. There are two ways to open ComboBoxes when they get the focus by using the tab keys.

When the ComboBox gets focus:

Press Alt + Down Arrow on the keyboard

For it to happen automatically, needs a bit of coding:

1. Add a combo box and a text box control to the form
2. Set the combo box's On Got Focus property to the following event procedure:

Private Sub ComboBoxName _GotFocus()

Me!ComboBoxName.Dropdown

End Sub

3. Open your form in Form View and use the TAB key to make sure it works.