Results 1 to 3 of 3
  1. #1
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 1 Time in 1 Post

    UpdateControls (Excel 2000)

    Near the end of a Private Sub there is a single line of code:
    UpdateControls

    I cannot find a reference to this in any of the three books I use. I must have put it there for some reason? Can someone tell me what it's purpose is and if I should leave it alone??
    - Ricky

  2. #2
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Dallas plus 20 miles or so, Texas, USA
    Posts
    876
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: UpdateControls (Excel 2000)

    I do not know of any such member of VBA. However, the code might possibly be calling another sub with the name "UpdateControls". If you go to the VBE and choose 'Edit/Find' you can search for the string and see if it might refer to another sub or procedure.

  3. #3
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: UpdateControls (Excel 2000)

    Yes it's true - I am wearing my moron hat tonight!

    UpdateControls IS the name of another sub - I need a break - I'm just amazed I didn't delete the call.

    Thanks
    - Ricky

Posting Permissions

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