Results 1 to 5 of 5

VBA _Change() command Question

Threaded View

  1. #1
    Registered User
    Join Date
    03-25-2009
    Location
    San Jose
    MS-Off Ver
    Excel 2007
    Posts
    83

    VBA _Change() command Question

    When I use that function on a UserForm it executes the code immediately, not waiting for the value to be entered.

    Thus the code executed that relies on the new values returns an incorrect value.

    Example

    A1 | 150
    A2 | 100 <-- this is the value being changed to 300 with the Textbox
    A3 | 250 = Sum(A1:A2)

    Now with:
    Private Sub TextBox_Change() 
    
        Range("B3").Value = Range("A3").Value
    
    End Sub
    it copies over the value of 250 while I'm changing the value to 300...

    Is there a way to get it to wait till I'm done changing the value first?
    Last edited by D3Pratt; 03-28-2009 at 06:55 PM.

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