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

Try :

Multipage1.Value = 0 '(Page 0 for first page, 1 for second... )

Before the line :
Me.tbResAddressLineOne.SetFocus

Pierre


"Azza" a écrit dans le message de
m...
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