MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Multi Page Controls


Posted by BlackmanR on September 07, 2001 8:03 AM

I have a four page control and i was wondering if there is anyway to bring the next page in focus when i get to the last textbox on the present page without having to select the page from the title bar. Anticipating any help whatsoever.

Rick


Posted by Ivan F Moala on September 07, 2001 8:22 AM

I'm assuming you mean a Multipage control on
a userform.
If so then to change pages you need to change the
multipages value property.
To do this after input from last textbox then I
suggest;

Private Sub TextBox2_AfterUpdate()
MultiPage1.Value = MultiPage1.Value + 1
End Sub

Ivan