View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Azza Azza is offline
external usenet poster
 
Posts: 7
Default How do I set the focus to a page in a multipage

I am checking that values have been added to pages in a multipage and
need to set the focus to the tab before i set the focus to the
textbox.

Currently it errors as the page is not in focus....

Here is the code:

'Checks if ADDRESS - LINE 1 is entered
If Me.tbResAddressLineOne = "" Then
MsgBox "Please complete the mandatory 'Address' fields",
vbInformation, mboxheader
'***CODE IN HERE TO FOCUS ON THE MULTIPAGE PAGE BEFORE TRYING TO FOCUS
ON THE BOX***
Me.tbResAddressLineOne.SetFocus
Exit Sub

Help appreciated

Cheers
aaron