RadioButtons

[bmayes]

Hi Lars -

I'm trying to implement radiobutton in Excel via your component. The problem I'm having is this:

I have added 3 radiobuttons into one cell using the rowoffset property and that works just great - comes out beautifully. The problem is that there is no group index or anything, so that the radiobuttons know that they belong to each other. When click on a radiobutton it is checked and then click on another it is checked , but the other previous radiobutton is since checked. How do I uncheck it? Is there something I'm missing??

Many thanks,
Brian

[larsa]

Hello

You have to put a group box around a radio button in order to group it.

Unfortunatley, group boxes are not implemented in the component yet.


Lars Arvidsson

[bmayes]

Oh, ok. Thanks for the quick responds. Can you think of a work-around for now??

Many thanks,
Brian

[larsa]

Hello

You can use an excel file (with group boxes) as template, anf then place the radiobuttons within the group boxes.


Lars Arvidsson

[bmayes]

Hello Lars -

That is one way, but I'm making the excel dynamically meaning that some cells might have radiobuttons and some will not. I can't distribute a excel file with the program. It is all developed at run-time.

Anybody have any suggestions??

Many thanks,
Brian

[bmayes]

[Message deleted]

I deleted you message as it was pointing users in the wrong direction. Your answer involved OLE, and XLSReadWriteII is not an OLE solultion. The whole idea with the component is to create excel files without having excel installed.

Lars Arvidsson

[bmayes]

Hello Lars --

You are absolutely correct! Sorry about that.

That is ok cuz I'm replacing the radio buttons with the drop down as it is the same thing anyway!

Thanks for your quick responds!
Brian