Tip Sharing Forms between VBA Applications

All VBA applications that use the Visual Basic Editor share features for creating custom forms. You can share your forms by exporting and importing form files or by dragging a form object to another project. To import or export a form file, choose File | Export or File | Import. Before you export a form file, make sure to select it in the Project Explorer window. Before dragging a form to a different VBA application, arrange the VBE windows so that you can see the Project Explorer window in both applications. Drop the form on the name of another project in the Project Explorer.

Properties - UserForm!

3

1 User Form I UserForm

m

Alphabetic Categorized ]

I [51 Appearance

T]

BackColor

□ &H8000000F&

BorderColor

■ &H80000012&

[Caption_

0 - fmBorderStyleNone UserForm 1

ForeCoior

■ &H80000012&

SpecialEffect

0 - fmSpecialEffectFlat

B Behavior

Cyde

0 ■ fmCydeAllFom*

Enabled

True

RightTaLeft

False

ShowModal

True

E Font

Font

Tahoma

□ Misc

(Name)

UserForm 1

DrawBuffer

32000

HelpContextlD

0

Mouselcon_

(None)

MousePointer

0 - fmMousePointefDefault

Tag_

WhatsThisfiutton

False

WhatsTNsHefp

False

Zoom

100

E Picture

Picture

(None)

PictureAbgnment

2 - fmPictureAlignmentCenter ▼ |

Figure 10-8:

Using the Properties window, you can easily change the appearance, behavior, and other features of your custom form.

0 0

Post a comment