View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
AKoodray AKoodray is offline
external usenet poster
 
Posts: 1
Default 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