Build a UserForm for Excel Fontstuff Ltd.（建立一个UserForm Excel Fontstuff有限公司）.pdf

Microsoft Excel VBA Fact Sheet: Build a UserForm for Excel Build a UserForm for Excel Introduction A UserForm is a custom-built dialog box that you build using the Visual Basic Editor. Whilst this example works in Excel you can use the same techniques to create a UserForm in any of the Microsoft Office programs that support VBA. With a UserForm you can create a user-friendly interface for your workbook or document, making data entry more controllable for you and easier for the user. About the Project This document shows you how to build a simple UserForm for entering personal expenses data on to a worksheet in Excel. The work is divided into two main sections: building the form itself and then writing the VBA code to make it work. The finished UserForm will look something like this (Fig. 1). Fig. 1 The finished UserForm project. NOTE: The screenshots here show how things look in Excel 2003 running on Windows Vista. If you are working in an different version of Excel or Windows the appearance will be slightly different but all the techniques explained here will be exactly the same. Build the Form Start Excel and open the Visual Basic Editor (keyboard shortcut: [Alt]+[F11]). You will need to use both the Project Explorer and the Properties Window so if they are not visible open them from the View menu. HINT: When building your UserForm try to avoid double-clicking on anything (unless the instructions tell you to do so) because this sometimes opens the forms code window. If you do this accidentally simply close the code window by clicking its Close button, or switch back to the UserForm design window with the keyboard shortcut [Control]+[Tab]. Insert a New UserForm Make sure that the current workbook (e.g. VBAProject (Book1)) is selected in the Project Explorer then open the Insert Menu and choose UserForm. When you do this a new, blank UserForm