Category Archives: vba

Worksheet radio button replacement in Excel VBA

Note: this works only for radio buttons on a worksheet and can’t be used in user forms

A recent security update by Microsoft broke one of my clients Excel VBA applications which was using MSForms 2.0 radio buttons. The Excel workbook in question shows several tabular ranges on a single sheet. Each table has radio buttons and list boxes attached for custom sorting and filtering. Unfortunately, only ActiveX controls (MSForms 2.0) support more than one radio button group on a single sheet – so there was no way to recur to inbuilt Excel sheet controls.

read more