Referencing check boxes from VBA to excel

[VBAmalta89]

I have a user form with a number of check boxes. Now when the user ticks the box in the form it returns a TRUE or FALSE value in the excel worksheet.

Is there a way where I can make it return whats written in the check box rather than simply true or false?

Thanks

 

[Tuelor]

If its links a true or false to a cell, couldn't you just add an IF statement next to it to toggle between the wording?

But to answer your first question, I don't think you can with a form control. You can do it with an ActiveX control, within the comboBox_change event.

D

 

[VBAmalta89]

Thats what im going to do now but i was hoping that there was a way to do it from VBA instead. Im new to this VBA business so im still getting used to it.

Thanks!