| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Control Order on User Form
I have created a UserForm with approx. 30 check boxes on
it. Each checkbox represents s page to be printed. I have created VBA code to cycle through each checkbox control and print the pages where the boxes are checked. For Each ctrl In PrintControlForm.Controls If TypeOf ctrl Is MSForms.CheckBox Then If ctrl.Object.Value = True Then Of course I would like to control the order in which the pages are printed. I assumed the TabIndex Property would be the key, but that does not seem to work. I am close but am not sure what is driving the order at this time. Allan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2007 Form Control/ActiveX Control font difference | Excel Discussion (Misc queries) | |||
| How do I fill a cell in a user form from a selection on same form? | Excel Discussion (Misc queries) | |||
| User Form Tab Order | Excel Discussion (Misc queries) | |||
| creating a checkbox control on a user form using VBA | Excel Programming | |||
| I am looking to see if anybody has an equivalant user form to Outlooks CONTACT form | Excel Programming | |||
Threaded Mode
