Results 1 to 2 of 2

Thread: Command button error

  1. #1

    Command button error

    Register for a FREE account, and/
    or Log in to avoid these ads!

    I created input userform. Eachtime i input any information in the userform and when i close the userform i should able to see the corresponding information in the excel row. But the excel is not doing auto filter which made me to create autofilter in the vb close button. But the issue is when i click close button in excel it taking atleast 4 mins to update each information. Does any one know why ? the code is below,

    private Sub CommandButton2_Click()
    Unload Me
    Worksheets("TPM FORM").Activate
    ActiveSheet.AutoFilterMode = False
    End Sub

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Excel Version
    Why are you hiding the form when you have already unloaded it, that will cause it to re-instantiate then hide.

Posting Permissions

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