Userform number validation - multitabbed form

[BuZZarD73]

Hi,
I use some validation for ensuring that certain fields are entered as numeric only in certain text boxes on my userforms:

Please Login or Register  to view this content.

It works fine on a single page form but just fails where a form has more than one page - specifically on the first if statement, as it doesn't seem to pick up the activecontrol as a textbox.

Is there something extra I need to add for a multipage userform?

Attached is an example with both form types to illustrate - just launch either form and type a non numeric value in.

Cheers.

[BuZZarD73]

Sorted!

Please Login or Register  to view this content.

needs to be

Please Login or Register  to view this content.

Spent most of yesterday wondering why it had stopped working and then within minutes of posting here, I figure it out!

[sanjaypalsjp]

Sorted!

Please Login or Register  to view this content.

needs to be

Please Login or Register  to view this content.

Spent most of yesterday wondering why it had stopped working and then within minutes of posting here, I figure it out!

Above also not work!

You solve your problem?

[BuZZarD73]

It's working fine for me.

Please Login or Register  to view this content.

remember to specify which page of the userform you want to run the code on by changing the value of

Please Login or Register  to view this content.

Please Login or Register  to view this content.

etc

[sanjaypalsjp]

You are right