+ Reply to Thread
Results 1 to 3 of 3

Cancel Calling Sub on TextBox_AfterUpdate

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    04-03-2012
    Location
    Washington State
    MS-Off Ver
    Excel 365
    Posts
    340

    Cancel Calling Sub on TextBox_AfterUpdate

    Hello,

    I am trying to figure out the best approach to a small problem I am having. I am using a textbox_afterupdate to call a sub. I also have a search button to populate my userform, but at that point I want to cancel calling the sub once the userform gets information. Here is what I am using:

    Private Sub txtStampNum_AfterUpdate()
    Call cmbFind_Click
    End Sub
    This works great for when I am manually entering data to the userform, but how can I cancel this when I am populating the form? When the data gets populated to the form, I no longer need to call this sub which brings up a message box.

    Thanks...

  2. #2
    Forum Contributor
    Join Date
    04-03-2012
    Location
    Washington State
    MS-Off Ver
    Excel 365
    Posts
    340

    Re: Cancel Calling Sub on TextBox_AfterUpdate

    I did find something for this, but I am not sure how it would work since the sub is a button and not a Module. I'm stuck...

    cmbFind_Click Cancel

  3. #3
    Forum Contributor
    Join Date
    04-03-2012
    Location
    Washington State
    MS-Off Ver
    Excel 365
    Posts
    340

    Re: Cancel Calling Sub on TextBox_AfterUpdate

    I am trying to reach out to the experts on this one.... can someone please tell me if this is possible? I cannot find anything related to such a thing.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1