ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Multipage Error Handling (https://www.excelbanter.com/excel-programming/288330-multipage-error-handling.html)

John Petty

Multipage Error Handling
 
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


Robin Hammond[_2_]

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





All times are GMT +1. The time now is 12:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com