Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hey gang,
I am having a hell of a time trying to work out how to fix my checkbox needs. I have a form (UserForm2) which I could now work out how to add checkboxes to whilst the program was running so i added them to the user form itself. I have 75 of them. I have overlapped them so I have 3 per line side by side so people can choose any one or all of three options for each line. Because the variable name for the objects is a straightforward variable, I am now finding I cannot address each of these in the program such as I would if I could in an arrange. Eg I have to address checkbox1 rather than checkbox(1). The latter would be good in arrays, even if you couldaddress the names such as Checkbox("Checkbox1") So I a was wondering how i would address each out. I need to make all checkboxes invisible except for ones that relate to lines irequire. Lines are determined by how many lines of reference numbers are put into userform1. I also require each series of 3 checkboxes names to the reference number. Therefore only every 3 hasit's label populated. Anybody able to point me in the right direction? I have read some things but it's lost me and I assume because my level of programming is more intermediate than advanced and I come from the old basic and pascal days, therefore objects aren't my forte. Help is appreciated and thank you in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Multiple checkboxes and aligning | Excel Discussion (Misc queries) | |||
Multiple Checkboxes | Excel Discussion (Misc queries) | |||
Multiple Checkboxes Shortcut? | Excel Discussion (Misc queries) | |||
Multiple checkboxes, one macro? | Excel Programming | |||
Multiple checkboxes 1 macro | Excel Programming |