'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.
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. Step 2: Click the row number at the left side of the spreadsheet that is below the bottom-most row that you want to freeze.įor example, we want to freeze the top 3 rows, so I have clicked row 4 in the picture below.UserForm Controls - Frame, MultiPage and TabStrip Step 1: Open your spreadsheet in Excel 2013. This same process can be applied to any number of the top rows in your spreadsheet.
If you are working with Excel for Mac 2011, then read this article instead.
The steps in this guide will show you how to freeze the top three rows of a spreadsheet in Excel 2013. Freezing Two or More Rows at the Top of a Spreadsheet in Excel 2013 (Guide with Pictures) Our article continues below with additional information on freezing cells in Excel 2013, including pictures of these steps. Choose Freeze Panes, then select Freeze Panes from the dropdown.Click the row number below the bottom row to freeze.Our tutorial below will show you how to freeze two or more of the top rows in your worksheet so that they remain fixed at the top of the sheet as you navigate further down on the worksheet.Ħ Additional Sources How to Freeze Multiple Rows in Excel 2013 But what if you have multiple rows that you want to keep visible at the top of the sheet instead?įortunately you can accomplish this as well, by taking advantage of the option to freeze a pane. Fortunately you can freeze the top row of your spreadsheet so that it remains frozen at the top of the sheet. But it can be difficult to remember which column contains which data as you scroll down and the headings row is no longer visible. But you might be wondering how to freeze multiple rows in Excel 2013 if you have several rows at the top of the spreadsheet that you want to keep visible.Ĭreating a row of headings to identify your columns in an Excel spreadsheet is a popular way to organize data. Using header rows in spreadsheet applications like Google Sheets or Microsoft Excel makes it much easier to identify information.