Excel Made Easy

Vba frame control display in Excel

The Frame control is also called as groupbox control.

As the name suggests, this control is used to hold a set of controls within its area.

This control is generally used with radio button or option button control.

So as to enable the user to choose more than one choice at a time.

The frame also has a number of properties, but are least bothered as it is mainly used as a container.

Some of the properties which are occasionally used are

1.Picture property

This is used to specify the background picture of the frame or container

2.PictureAlignment

This property is used to specify the position or alignment of the picture

3.PictureSizemode

This property is used to specify the size of the picture to be used in the control.

The following figure shows the use of frame control

From the above screenshot, there are two frames namely "Frame1" and "Frame2".

Each frame has two optionbuttons and the user can select 2 options.

But without the frame control, the user can select one and only one choice alone.

You can find similar Excel Questions and Answer hereunder

1) How to control forms in Excel VBA

2) Here an explanation about checkbox and how to control checkboxes in Excel VBA

3) How can I display fractions as it is in a cell (instead of displaying as a decimal)?

4) How can I get users to select a file for processing using my macro?

5) Here an explanation about combo boxes and interfacing with your user in Excel VBA

6) How can I display list of NAMES in a worksheet?

7) Here an explanation about buttons in VBA

8) Here an explanation about label controls in the various forms and controls using VBA

9) How can I remove display of Gridlines in my worksheet using VBA?

10) Here an explanation about text box and how to control text boxes in Excel VBA