activex form controls

I am trying to create a form in excel. With certain questions the user can select multiple options. For instance: What type of fruit would you like? (I used an active x combo box for this) No Fruit Apples Oranges Pears Grapes I want the user to be able to pick multiple options at once...

Firstly my apologies as I know this has been asked before but I still cannot get it to work. I'm using option buttons from the Form Control menu, the ActiveX Control menu is ghosted, as is the design toolbox button. I have no idea how to un-ghost them. No matter how I group and re-name and set...

Hello everyone, While I know how to use option buttons in the Developer tab under Form Controls, I am new to the ones in ActiveX. I believe I need to use the ActiveX ones, based on the following criteria, but correct me if I'm wrong: 1. I have 5 sections on the same "survey" form (one page) that...

I'm trying to add ActiveX controls to my worksheet. Here are the lines of code that I think are relevant. If I run my procedure, I receive the following error: “Can’t enter break mode at this time.” Then, I click Continue and another error message appears. “Run-time error ‘438’: Object doesn’t...

Hi all I already have a VBA code which allows me to have crosshatchings which helps to prevent me inputting errors. Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Cells.Count > 1 Then Exit Sub Application.ScreenUpdating = False ' Clear the color of all the...