can the tab order be changed based on

Feb 21st, 2002, 10:03 PM

option buttons? for instance, if OB1 is selected, all textboxes are included in the tab order. If OB2 is selected, textbox1 & textbox4 are removed from the tab order.

Thanks for the help

dk · Feb 22nd, 2002, 04:57 AM

Yeah sure - you can change the TabStop property of your textboxes at run-time e.g.

Private Sub OB2_Click()
If OB1.Value = True Then
Me.TextBox1.TabStop = False
Me.TextBox4.TabStop = False
Else
Me.TextBox1.TabStop = True
Me.TextBox4.TabStop = True
End If
End Sub

Private Sub OB1_Click()
If OB2.Value = True Then
Me.TextBox1.TabStop = True
Me.TextBox4.TabStop = True
Else
Me.TextBox1.TabStop = False
Me.TextBox4.TabStop = False
End If

End Sub

HTH,
D

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 21st, 2002, 10:03 PM	#1
Guest Posts: n/a	option buttons? for instance, if OB1 is selected, all textboxes are included in the tab order. If OB2 is selected, textbox1 & textbox4 are removed from the tab order. Thanks for the help

Feb 22nd, 2002, 04:57 AM	#2
dk MrExcel MVP Join Date: Feb 2002 Location: Sydney, Australia Posts: 2,908	Yeah sure - you can change the TabStop property of your textboxes at run-time e.g. Private Sub OB2_Click() If OB1.Value = True Then Me.TextBox1.TabStop = False Me.TextBox4.TabStop = False Else Me.TextBox1.TabStop = True Me.TextBox4.TabStop = True End If End Sub Private Sub OB1_Click() If OB2.Value = True Then Me.TextBox1.TabStop = True Me.TextBox4.TabStop = True Else Me.TextBox1.TabStop = False Me.TextBox4.TabStop = False End If End Sub HTH, D