200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
hello
I designed userform contains two multipage , each multipage linked with specific sheet it supposses copying to the specific sheet but all my codes in userform doesn't work I know there is smome thing is missed becuase of tool of " MULTIPAGE " so I truly appreciate if anybody looks my file and guide me what I have to do
thanks
Your UserForm1 contains two pages, Page1 and Page2. Each of these pages contains a frame, Frame1 and Frame3. Now my question. Where is TextBox1?
You can't see the answer. It was determined by the sequence and the exact way in which the controls were created. But you can test.
Only one of these will work because TextBox1 is in only one of these locations. The same applies to your command buttons. With a single click you can move from Me.Page1.Frame1.TextBox1 to Me.Page1.Frame2. It's incredibly complex, meaning it must be set up incredibly exact.
Your setup is of unknown quality. But,by not naming the controls, you made it very difficult for anyone but yourself to find his way around. I think, if your form is created perfectly and everything named clearly it will be very difficult to help you. By taking a less demanding approach you might reach your goal easier.
Edit 26 Mar 2021 =======================================
OK, Leopard. The code you want is in the attached workbook. There is some action you need to take. Please look into the comments. Come back to this post when you hit the problems I'm anticipating. Good luck!
