Userform Example (Biologic Data)
Userform with Option Button and Frame.Biologic Data Userform is an example useful to learn Excel Vba Programming.
In this Biologic Data Form, the physical attributes like height,weight, complexion,hair color and education & experience can be grouped in two particular Frames. Frames are particularly useful to group two or more OptionButtons.
Chapter headings of this form:
-Field of Work
-Exp in Years
A few examples of the UserForm codes:
‘populate ListBox of “Height” in the Frame “Physical Attributes”:
For i = 140 To 200
.AddItem i & ” cms”
‘populate ListBox of “Weight” in the Frame “Physical Attributes”:
For i = 80 To 250
.AddItem i & ” lbs”