Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hey all
I have just started using multipages in a form as I have heaps of info to extract. The problem is I do not know how to set the focus from one page to the next. I have field validations and when they trigger and the multipage is on another page I get a notinfocus error. I have these sort of validations: 'Checks if REFERRAL SOURCE is entered If Me.cbRefSource = "" Then MsgBox "Please enter the 'Referral Source'", vbInformation, mboxheader Me.cbRefSource.SetFocus Exit Sub End If and need to get the form to goto the page first. Please help - will be appreciated. Aaron |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula (off form) that completes form data based on a result | Excel Worksheet Functions | |||
Using a template form, advance a form number everytime you open | Excel Discussion (Misc queries) | |||
MultiPages | Excel Programming | |||
Is it possible to open the VBA form with a link in a sheet and to pass variable from a cell to the VBA form? | Excel Programming | |||
Scrolling in Multipages | Excel Programming |