USERFORM IN EXCEL VBA TUTORIAL CODE

By default, a MultiPage control has 2 Pages. The Pages are numbered from 0, and to select the first Page in a MultiPage control, use the code: Multi.Value = 0. Each Page of a MultiPage control has its own tab order. A MultiPage control has several Pages, wherein selecting a Page makes it the current one (making it visible) while hiding the others. All controls that are added to a Page in a MultiPage control, are contained in and become a part of that Page which distinguishes the controls from those which are otherwise a part of the UserForm. MultiPage is best used when you wish to handle a large amount of data that can be classified into multiple categories, wherein a separate Page can be created for each category. Me. = ''Ī MultiPage control comprises of one or more Page objects, each containing its own set of controls. 'on selection, clears 'University/Institution' TextBox of the Frame 'Education & Experience' Private Sub txtUniversityInstitution_Enter() 'on selection, clears 'Name' TextBox of UserForm 'enter value in 'University/Institution' TextBox of the Frame 'Education & Experience': 'populate ListBox of 'Exp in Years' in the Frame 'Education & Experience': MyArray = Array('Finance', 'Banking', 'Medical', 'Engineering', 'Marketing', 'Management', 'Airlines', 'Others') 'populate ListBox 'Field of Work' in the frame 'Education & Experience': 'populate ListBox of 'Weight' in the Frame 'Physical Attributes': 'populate ListBox of 'Height' in the Frame 'Physical Attributes': 'populate ListBox of 'Age' in the UserForm: Me.fraEduExp.Caption = 'Education & Experience' Me.fraPhyAttr.Caption = 'Physical Attributes' 'enter value in 'Name' TextBox of UserForm: 'Set properties of Controls on initialization of UserForm.

USERFORM IN EXCEL VBA TUTORIAL CODE

MsgBox ctrl.Name & ' is an enabled OptionButton with caption ' & ctrl.CaptionĮxample 2: Using Controls in a Frame with vba code (refer Image 25): If TypeOf ctrl Is MSForms.OptionButton Then 'determine name and caption of all enabled OptionButtons in a Frame Using a Frame: First add the Frame in a UserForm and then add Controls to the Frame.Įxample 1: Determine name and caption of all enabled OptionButtons in a Frame Primarily, Frames are used for 2 purposes: (i) to group related Controls in a UserForm to visually enhance and organize the Form's layout and (ii) to group OptionButtons to set their behaviour - they become mutually exclusive within a Frame and selecting one OptionButton will de-select all other OptionButtons within that Frame only. Frames are particularly useful to group two or more OptionButtons. For example, in a BioData Form, the physical attributes like height, complexion, weight and hair color can be grouped in a particular Frame. They also enhance the UserForm's layout by bunching and organizing a related set of items. Note: In below given examples, vba codes are required to be entered in the Code Module of the UserForm, unless specified otherwise.įrames are used to group controls that work together, are related to each other or have some commonality, in a UserForm. UserForm and Controls - Properties ' for properties common to the UserForm and most Controls

Using ActiveX Controls on a Worksheet have been illustrated in detail, in the separate section of ' Excel VBA: ActiveX Controls, Form Controls & AutoShapes on a Worksheet'.Īlso refer ' 2. By itself, a UserForm will not be of much use unless ActiveX controls are added to it which are the actual user-interactive objects. UserForm acts as a container in which you add multiple ActiveX controls, each of which has a specific use and associated properties. UserForm Controls - Frame, MultiPage and TabStrip

Userform in excel vba tutorial