PDA

View Full Version : Error in user form



Ellyna
01-06-2021, 09:19 PM
I faced this error. Can anyone help me ?
27685

Bob Phillips
01-07-2021, 08:02 AM
Probably best to post the workbook, and tell us how to reproduce the error. A picture is hard to work from.

Ellyna
01-10-2021, 06:53 PM
Sorry for the late reply. I will attach the workbook.
I copied the workbook in another PC and try to open it but when i wanted to saved it, it occur error shown as above. But it works fine on my laptop.

gmayor
01-11-2021, 01:12 AM
Apart from an undeclared variable 'c' in
For c = 1 To 7 and the use of Option Explicit only in some of the modules (which would have revealed that error) the code appears OK.
The error message relates to the button which calls the userform page 2 (the summary). The error shows a call to page 0 (packing tab) and your photo shows a different button arrangement from the attachment.

Ellyna
01-14-2021, 08:20 PM
Thank you for the explanation. I already redo the whole workbook. :biggrin:
Do you know how can i resize the form ? because some form have lot of space

NoSparks
01-15-2021, 09:09 AM
Do you know how can i resize the form ? because some form have lot of space

Didn't dmt32 give you that over at MrExcel (https://www.mrexcel.com/board/threads/multipage-user-form-and-how-to-insert-each-user-form-into-different-sheets.1156338/)

Look at the MultiPage1_Change event for the resizing
and the FormPosition sub for positioning the form on the screen