ExcelBanter - Multipage

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Multipage (https://www.excelbanter.com/excel-programming/293020-multipage.html)

Aksel Børve

Multipage

I have a Userform with 4 Multipages, first Multpagpage belong to sheet1,
second Multipage to Sheet2, and so on. Is there a possibility to get e.g.
Multipage3 on Top when I open the Userform from Sheet3?
Thanks.
Aksel Børve

JE McGimpsey

Multipage

If I understand you correctly:

Private Sub UserForm_Initialize()
MultiPage1.Value = ActiveSheet.Index - 1
End Sub

In article ,
"Aksel Børve" wrote:

I have a Userform with 4 Multipages, first Multpagpage belong to sheet1,
second Multipage to Sheet2, and so on. Is there a possibility to get e.g.
Multipage3 on Top when I open the Userform from Sheet3?
Thanks.
Aksel Børve

All times are GMT +1. The time now is 03:44 AM.