Code for using in VB to create check boxes and radio buttons

bretm333666999 · Mar 15th, 2002, 02:42 PM

Does anyone know what code I would use to create a functional check box and radio button within my worksheet?

Al Chara · Mar 15th, 2002, 02:56 PM

You don't need code to create check boxes or option buttons on a worksheet. Its as easy as drag and drop

The following codes will add a check box and an option button to a userform:
Set MyCheckBox = Controls.ADD("Forms.CheckBox.1")
Set MyOptionButton = Controls.ADD("Forms.OptionButton.1")

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 15th, 2002, 02:42 PM	#1
bretm333666999 New Member Join Date: Mar 2002 Location: EAC Posts: 3	Does anyone know what code I would use to create a functional check box and radio button within my worksheet?

Mar 15th, 2002, 02:56 PM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	You don't need code to create check boxes or option buttons on a worksheet. Its as easy as drag and drop The following codes will add a check box and an option button to a userform: Set MyCheckBox = Controls.ADD("Forms.CheckBox.1") Set MyOptionButton = Controls.ADD("Forms.OptionButton.1")