How to send the caption of a checkbox or option button to a database

[kelly mort]

Hello
I need help how to send the caption of checkbox or option button to a database in Excel. These controls are sitting on a userform.

Thanks

 

[jproffer]

I can't test it at the moment, but I think something like this would do that:

Range("A1").Value = Userform1.CheckBox1.Caption  'Or Checkbox1.Text or something like that.  It has some property to set the text that you see beside the box, that's the one.

This is oversimplified to what I'm sure you're up against putting it where you want it in your database, but it could be adapted to a "non-hard coded" Range.

 

[kelly mort]

Okay thanks. It helped me to get what wanted.

Kelly

 

[jproffer]

Glad to help. Thanks for the feedback.