option button array?

[CPerdue]

Hi all,

I'm trying to design a table for data entry. Line items (outputs) are pre-populated, and it is up to the user to specify which, if any, function they perform by choosing selection objects from various columns.

Depending on other data, I want to control what the user is able to select.
Case 1, only one selection per column, only one selection per row.
Case 2, multiple selections per column, only one per row.
Case 3, freeform, select all you like.

I know the option buttons allow grouping to restrict choices to one per group. I could group as rows for case 2 but I don't see a way to use the group properties for the other cases. I think I will have to use un-grouped buttons (or check-boxes) and do the housekeeping myself. Suggestions?



Thanks,
Clint

 

[CPerdue]

Not if I've got the event free!

Thanks all.

C.

 

[shg]

Events are always free ...

 

[CPerdue]

True, what I meant was that I'm already using the BeforeDoubleClick (and onWorksheetChange for that matter) event. If I use this method then I will simply have to decide why the double click happened...check box or other. No biggie.

 

[shg]

The code in the double-click event associated with the checkbooxes properly belongs as a sub in a code module, and the event should just call it, along with anything else it needs to do:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    Marlett Target
    ' other double-click code goes here
End Sub

We all tend to provide examples where the application code is in the event handler, but in practice, it's bad practice.