allow three Toggle button only at a time and capture the value in a range

[manojsahooin]

Hi Team,

I have 20 Toggle buttons in a form, i want user to select max 3 toggle buttons only, and then capture the Toggle button value in a range.

Below is the code which i am currently working and needing help to resolve this.

in class module:

Please Login or Register  to view this content.

-------------------------------------------------------------------------------------------------------------------------------------------------------------------

In Form:

Please Login or Register  to view this content.

[Greg M]

Hi there,

When you say:

and then capture the Toggle button value in a range

do you mean that you want to capture the values of the three "pressed" ToggleButtons? Do you want to store three separate values in three cells in a specified Range?

Regards,

Greg M

[manojsahooin]

Hi Greg,

Yes, want to store the vale in three cells in a specified range

[Greg M]

Hi again,

I'm not at my computer at the moment but I will have something to send you later today.

Regards,

Greg M

[Greg M]

Hi there,

On reflection, I don't think that returning the Value properties of the selected ToggleButtons will be very useful (after all, they'll obviously all be TRUE! ), so instead I've returned the values of the Caption properties of the selected ToggleButtons.

Take a look at the attached workbook and see if it does what you need. It uses the following code in a standard VBA CodeModule:

Please Login or Register  to view this content.

the following code in the VBA CodeModule of the UserForm:

Please Login or Register  to view this content.

and the following code in the VBA CodeModule for the ToggleButton Class:

Please Login or Register  to view this content.

The highlighted values may be altered to suit your requirements.


Hope this helps - please let me know how you get on.

Regards,

Greg M

[manojsahooin]

thank you Greg, you have resolved my issue. Thank you..Thank you..Thank you..Thank you..a big thank you

[Greg M]

Hi again,

Many thanks for your feedback.

You're welcome, you're welcome, you're welcome - glad I was able to help.

Regards,

Greg M

[manojsahooin]

Hi Greg,

I created one more form in the same workbook you provided and few more toggle buttons (so two form with toggle buttons) , i copied the code from your form, however second form which i created throws me run time error, could you please advise if i need to change something in the code. Also in the code : (Const sSELECTED_BUTTONS As String = "A1:A3" ), if i change it to "A1:C1" it still captures the value in "A1:A3". please advise

Thank you again for all your help

[Greg M]

Hi again,

The line

Please Login or Register  to view this content.

assumes that the target range is part of a single column.

If the target range is part of a single row you should use

Please Login or Register  to view this content.

You could possibly use the following (untested) code, but my personal preference is always to specify both the row and the column of the target range

Please Login or Register  to view this content.

As far as the other UserForm is concerned, I would need to see it before I could make any meaningful suggestion. Can you post it here?

Regards,

Greg M