How do I make a combobox class and an Optionbutton Class?

  • I need to make it known when a combobox or optionbutton was clicked. This can be in two separate classes. What I have tried is this:

  • I have moved your question to the correct Forum.


    See if this example helps.

  • That sort of works. What I'm seeing is that the classes are able to give me the name of the control, but it appears to loose the "Hooks" and I have to rerun the hook before I can click on a combobox that is in a cell. I used activex comboboxes mostly just becasue I could set the font to bold. I can't do the with combo form control.


  • Forms Controls are the most reliable


    RoyUK - I need an activeX control because of the font and the backcolor.


    Any idea what is causing the comboboxes to become "unhooked"?

  • I don't have any issues in the sample workbook. I can click multiple combos without any issues.

    Thanks for looking. Perhaps this is happening due to interference from my other code. My workbook is using ado and sql server queries.

  • Yes, it seems to. I could attach my workbook, but I don't want it made public. You wouldn't have the databases but I could make it work with a list page just to show you.

  • I commented out the database calls and the classes did seem not to fail as they did before. Guess I'll try adding back the database calls one step at a time and see what's causing it to fail.


    Appreciate you help and insight!