View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Robin Hammond[_2_] Robin Hammond[_2_] is offline
external usenet poster
 
Posts: 575
Default Multipage Error Handling

John,

I do something like this with the same intent. The name for this page is
pgCompanies.

With mpQuery
If .Value = .pgCompanies.Index Then
'do something
end if
end with

Robin Hammond
www.enhanceddatasystems.com

"John Petty" wrote in message
...
I am trying to code some error handling for a Mulitpage
form, that checks to see if a certain form is active
before writing data. I would like to use the page names
instead of the page values (easier for another programmer
to work with).

I would like to code something like this

If Multipage1.name < "PageRelease" or MultiPage1.Name _
< "PageChange" then
MsgBox("You must have an EO Form Active to use this _
Wizard" & vbCrLf & "Please open an EO Form and _
try again")
Exit Sub
Else
My code here

Any suggestions?

Thanks for your help

John Petty