Moving A Userform Frame To A Multipage Page In The Same Userform

Ark68

Well-known Member
Joined
Mar 23, 2004
Messages
4,570
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
I have a userform. On this userform, I have a multipage control (multipage1) with 3 pages , the first page (value=0) named "MAIN".
Elsewhere in this userform, I have a frame, named "f4_crew_review".

I'm trying to code the run-time move of frame "f4_crew_review" to multipage1 "MAIN" page.

If I simply code top and left values for the frame in my code, it places it relative to the userform, not the multipage page. How can I ensure the frame is placed within the appropriate multipage page?

Code:
Private Sub v_crews_Click()
    uf9_poststaff.Width = 421
    With MultiPage1
        .Width = 408
        f4_crew_review.Top = 6
        f4_crew_review.Left = 162
    End With
   
    f1_employee_info.Visible = False
    f2_staff_schedule.Visible = False
    f3_staff_hours_review.Visible = False
    f4_crew_review.Visible = True
End Sub

Has anyone any guidance for me?
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
Maybe this would work...

Code:
Private Sub v_crews_Click()
    uf9_poststaff.Width = 421
    With MultiPage1
        .Width = 408
        f4_crew_review.Top = MultiPage1.Top + 6
        f4_crew_review.Left = MultiPage1.Left + 162
    End With
   
    f1_employee_info.Visible = False
    f2_staff_schedule.Visible = False
    f3_staff_hours_review.Visible = False
    f4_crew_review.Visible = True
End Sub

Or something along those lines.

See what happens :)
 
Upvote 0
Thank you jproffer, that worked very well.
 
Upvote 0

Forum statistics

Threads
1,223,884
Messages
6,175,177
Members
452,615
Latest member
bogeys2birdies

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top