Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform CheckBoxes
I have a userform that contains a large amount of text boxs. They are
organized in columns according to their type. In each comlumn I want the user to only be able to select one checkbox from any single column at a time. I know it is possible to write into each checkbox control code individually but this seems exceedingly wasteful. Is there a general event on the userform when ANY control is pressed and that will return the value and name of the pressed control??? Or is there another way to do this operation??? Any help, Thanks, Ben |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform CheckBoxes
Hi
Checkboxes are made for multiple selections. I think you need to use Optionbuttons. For each column, place a frame on the userform and place optionbuttons in the appropriate frame. Only 1 optionbutton per frame can be selected. HTH Ken |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform CheckBoxes
Excellent
Thank you very much, that worked much better "Ken Macksey" wrote: Hi Checkboxes are made for multiple selections. I think you need to use Optionbuttons. For each column, place a frame on the userform and place optionbuttons in the appropriate frame. Only 1 optionbutton per frame can be selected. HTH Ken |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Userform Checkboxes | Excel Discussion (Misc queries) | |||
Userform with Checkboxes | Excel Discussion (Misc queries) | |||
Count CheckBoxes in UserForm | Excel Programming | |||
Can't check checkboxes in userform ... sometimes | Excel Programming | |||
UserForm Checkboxes | Excel Programming |