Consulting

Results 1 to 3 of 3

Thread: Making VBA userform, ChangeButton does not work

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1

    Making VBA userform, ChangeButton does not work

    Hi,

    I'm currently making Data Entry Userform in Excel using VBA. Basically, I used VBA to make a UserForm to search, change, add and delete the data in Excel Worksheet.I'm having a problem when I click changeButton in my Userform it appears an error.

    This is my UserForm (with an error):

    Userform.jpg

    I'm stuck on how to solve this problem. Can you help me, Thank you

    So here I'm attached my file:
    Attached Files Attached Files

  2. #2
    VBAX Master paulked's Avatar
    Joined
    Apr 2006
    Posts
    1,007
    Location
    Hi there.

    I'm not sure why it is doing this, but I am wondering why you call 'listbox1_refresh' and then you clear the listbox?

    If you don't call the refresh it seems to be ok.
    Semper in excretia sumus; solum profundum variat.

  3. #3
    Thank you for your reply. Yes, its true paulked after I remove call listbox1_refresh its work perfectly.

Posting Permissions

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