Consulting

Results 1 to 6 of 6

Thread: Error in user form

  1. #1
    VBAX Newbie
    Joined
    Nov 2020
    Posts
    3
    Location

    Error in user form

    I faced this error. Can anyone help me ?
    WhatsApp Image 2021-01-07 at 12.17.54 PM.jpg

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,443
    Location
    Probably best to post the workbook, and tell us how to reproduce the error. A picture is hard to work from.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  3. #3
    VBAX Newbie
    Joined
    Nov 2020
    Posts
    3
    Location
    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.
    Attached Files Attached Files

  4. #4
    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.
    Graham Mayor - MS MVP (Word) 2002-2019
    Visit my web site for more programming tips and ready made processes
    http://www.gmayor.com

  5. #5
    VBAX Newbie
    Joined
    Nov 2020
    Posts
    3
    Location
    Thank you for the explanation. I already redo the whole workbook.
    Do you know how can i resize the form ? because some form have lot of space

  6. #6
    VBAX Regular
    Joined
    Feb 2013
    Posts
    52
    Location
    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

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •