Thread: Multipage
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default 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