Referencing an ActiveX combo box

[gibbsa08]

Hey guys,

Haven't worked with ActiveX controls in a while so I'm a little rusty. I'm trying to figure out how to assign a "score" based on the users selection from the combo box. This score is saved and should update whenever the value in the combo box changes. Here's what I have so far but I can only get a score of "1" to show up.

Please Login or Register  to view this content.

Thanks in advance!

[humdingaling]

where is your output?

[Kyle123]

You're better off not using ActiveX controls on worksheets at all. They're incredibly unstable have a look here https://www.google.co.uk/webhp?sourc...eet%20controls and by using them, you're asking for trouble.

Forms controls are much more reliable - they're in the same dropdown as the ActiveX ones, but are designed for use on worksheets - so you don't run into any stability issues, you can do most of the same things with them too and you can use them without using code.

[gibbsa08]

IB555.xlsmI've went ahead and changed over to form controls and built the project using a user form. I've attached the form for reference. The problem I'm running into now is that these scores will only sometimes populate the ranges I want them to. I know this should be an easy fix using debugging but for whatever reason I can't seem to figure it out.

[gibbsa08]

Figured it out...There was an extra space in the "mostly" cell at the end causing the macro to completely jump over it in the if statement.

[humdingaling]

Glad you figured it out
For your information for future questions
your latest example is Userform Combobox which is different to Activex combo box and Form control (in which Kyle was referring to)

https://support.office.com/en-za/art...rs=en-ZA&ad=ZA
they each code slightly different to one another

see attached how Form looks like
there is minimal coding involved just some algebra work to figure out the decimals