CODEWITHSUNDEEP
formsvbamultipage
themolestones
themolestones

Reputation: 203

MultiPage Form Identify VBA

it might be the silliest question anyone ever asked, but I have been looking for a long time and I could not find an answer.

I have a form with a multipage with 2 pages, and I want to know which page is the one the user is filling up when he presses the ComandButton (which page is the user viewing at that moment). I want that because depends on which page the data will be inserted in diferent place.

If more info is needed, just let me know.

Thanks.

Upvotes: 1

Views: 925

Answers (1)

brettdj
brettdj

Reputation: 55692

For a control called MultiPage1 you could return the page as below

For example

`1st tab
Me.MultiPage1.Value = 0
`3rd tab
Me.MultiPage1.Value = 2

Upvotes: 1

Related Questions