Ning user forms

To b uild an application that uses forms, you must first design the form. Enter the VBE from Excel using [Alt]+[F11]. Make sure that both the Project Explorer and Properties panes are visible (see Figure 10.1). If they are not, use View > Project Explorer or View > Properties. To add a form, use Insert > UserForm. A blank form will appear. A great deal of thought is needed now as this will be the user's interface to the application.

I Microsoft Visual Basic - Bookl - [UserForm 1 (UserForm)]

IzU File Edit View Insert Format Debug Run lools Add-Ins Window Help

Project - VBAProject m ai

■ (Q Sheet; (ShestS) » ■] Shœt3 (Shçjt 3} Ö ThisWoflbooL □ Forri>£

Properties - UserForm 1

UserForml UseiFoim ^

Alphabetic | tattgweai |

Properties - UserForm 1

UserForml UseiFoim ^

Alphabetic | tattgweai |

(Name)

[ UserForm 1

-

BackCoior

□ &H8000000F

BordsrColor

■ ¡¿H8000001 ;

Border St vie

0 - fmBorderStv

Caption

UserForm 1

Cycle

0 - fmCydeAllFc

DrawBuffer

32000

Enabled

true

Font

Tahoma

ForeCoior

■ &H8000001;

Height

198.75

Help Con text ID

0

KeepbcrollBarsVis 3 - frrbcrollBars

Left

0

Mouselcon

|(None)

MousePointer

0 - fmMousePoii

Picture

(None)

PictureAlignment

2 - fmPictureAlic

Picture5izeMode

0 - fmPictureSiz T i

Default User form displayed

Default User form displayed

Figure 10.1 The screen layout when a new user form is selected

0 0

Post a comment