How to Add Radio Buttons in Excel (2 Effective Ways)

Get FREE Advanced Excel Exercises with Solutions!

This article illustrates how to add radio buttons in excel. The radio buttons, usually known as option buttons, let users choose from different options. It is a control that enables us to pick a single option from a limited set of mutually exclusive options.

Radio buttons are used extensively almost everywhere. In Excel, selecting a radio button from a group of them will return the order of the button in that group. You can link the radio buttons to a cell to get the return in that cell and then use the reference of the linked cell in logical functions to get the desired results. Follow the article to learn how to add radio buttons in Excel.


There are 2 basic ways to add radio buttons in Excel. Now we will discuss them in detail.

1. Adding Radio Buttons Using Option Button (Form Control) Command

Follow the steps below to add radio buttons without any macros using the Form Control command in Excel.

📌 Steps:

Add radio button

  • Next, drag the cursor as required to insert a properly sized radio button.

drag cursor to resize

  • After that, you will see the following result. You can drag the small circles to resize the button.

added option button

  • Now right-click on the radio button and select Edit Text.

Edit Text of radio button

  • Then you can rename the radio button as required.

rename radio button

  • Next, right-click on the radio button and select Format Control.

Format Control radio button

  • Next, enter a cell reference to link the radio button to the cell from the Control tab. You can also mark or unmark the radio button by selecting Checked or Unchecked respectively. You can also edit the radio button as required from different tabs in the Format Control dialog box.

link radio button to a cell

  • Now if you mark the radio button, it will return a 1 in the linked cell.

mark the radio button


Similar Readings


2. Inserting Option Buttons in Excel with Macro

Follow the steps below to insert an Option Button with a macro in Excel.

📌 Steps:

  • First, select the Developer >> Insert >> option Button (ActiveX Controls).

add radio button from ActiveX Control

  • Then drag the mouse as earlier to insert the radio button. After that, you will see the following result.

add radio buttons

  • Now, right-click on the radio button while in Design Mode and select Properties.

select properties

  • Then, you can edit all the properties as required from the Properties window.

change properties of the added radio button

  • Next, right-click on the radio button and select View Code. This will automatically insert a private subroutine procedure in the worksheet module.

select View Code

  • Now, copy the following code and paste it inside the subroutine procedure.
Range("D3").Interior.Color = vbGreen

add code for radio button

  • Then uncheck Design Mode and mark the radio button to see the following result.

mark radio button to see output

Read More: How to Create a Macro Button in Excel


How to Add Multiple Radio Buttons in Excel

Follow the steps below to add multiple radio buttons in excel.

📌 Steps:

  • First, insert a radio button by selecting Developer >> Insert >> Option Button (Form Controls) as earlier.
  • Then, select the radio button in design mode and press CTRL+C to copy it.
  • Next, press CTRL+V or CTRL+ D as many times as the number of radio buttons needed.

add multiple radio buttons

  • Alternatively, select the cell that surrounds the radio button. Then drag the fill handle icon to copy the radio button as many times as required.

copy cell to add multiple radio buttons

Read More: How to Create Button Without Macro in Excel


How to Group Radio Buttons in Excel

You can select only one radio button in each worksheet. This is not desired at all if you need to allow your users to choose from several types of options. Assume you have created 15 questions for a survey. Each of the questions has a different number of options to choose from. Then you must group the radio buttons for each question separately. Follow the steps below to learn how to do that.

📌 Steps:

  • First, select Developer >> Insert >> Group Box (Form Control) as shown below.

insert groupbox

  • Then drag the mouse around the radio buttons that you want to group together.

drag cursor around the radio buttons to group

  • After that, you can select a radio button from each group as shown below.

grouped radio buttons

Read More: How to Insert Excel VBA Radio Button Input Box


How to Delete/ Unmark Radio Buttons in Excel

Follow the steps below to delete or unmark the radio buttons in Excel.

📌 Steps:

  • First, click on Design Mode in the Developer Then select the radio button that you want to delete.
  • Now press the Delete key on the keyboard. After that, the radio button will be deleted.

delete radio buttons

  • You need to mark the radio button for Unchecked in the Format Control dialog box to unmark a radio button created using the Form Controls command.
  • On the other hand, you need to set the Value property to False in the Properties window if the radio button is created using the ActiveX Controls command.

Read More: How to Remove a Form Control in Excel


Things to Remember

  • You must enable Design Mode in the Developer tab to be able to edit the radio buttons.
  • Don’t forget to save the workbook as a macro-enable workbook if you applied macros to the radio buttons.

Download Practice Workbook

You can download the practice workbook from the download button below.


Conclusion

Now you know how to add radio buttons in Excel. Do you have any further queries or suggestions? Please let us know in the comment section below. Stay with us and keep learning.


Related Articles

Md. Shamim Reza
Md. Shamim Reza

Hello there! This is Md. Shamim Reza. Working as an Excel & VBA Content Developer at ExcelDemy. We try to find simple & easy solutions to the problems that Excel users face every day. Our goal is to gather knowledge, find innovative solutions through them and make those solutions available for everybody. Stay with us & keep learning.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo