changing optionbutton.value if = true to have result "1" in cell

[Ceeseven]

Once again, after searching and failed attempts, help is needed. i did try examples of other solutions found in the forum. Is there a simple solution, by changing something in the button properties?

My current code below allows data from a userform to goto specific sheets and cells. Currently my option button named winbutton if true will display "true" in cell. i need it to be numerical value "1". Help please?

Thanks.

Please Login or Register  to view this content.

[royUK]

Try

Please Login or Register  to view this content.

[Ceeseven]

thanks again Roy.

i will try it and let you know.

[Ceeseven]

Roy it works perfect.

Thank you.

[Sven62]

Would this work?

Please Login or Register  to view this content.

[Norie]

Here's a slightly different way.

Please Login or Register  to view this content.

You don't say what to put in the cell if the button is false so I've used 0.

[Sven62]

Sorry, yeah you're right. I had my cells conditional formatted =A1<>1 white font so it looks blank.

[protonLeah]

Sven62, Norie, this thread is 4 years old.

Ceeseven hasn't been around since 05-10-2010 08:54, so what's the point?