Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Oct 2001
    Location
    Not in KC anymore
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Edit VB Code (2007)

    Hello all,

    I have a worksheet that contains numerous (almost 50) subs that I need to edit in order to customize for different members of my team. In each one, I'll be changing just a small portion of the code.

    Is there a quicker way to do this other than opening up each sub and finding the text to edit and making the changes manually?

    The subs are code behind Command buttons in UserForms if that makes any difference.

    Thanks!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Edit VB Code (2007)

    You can use Edit | Replace...
    Select Current Project in the Search group of option buttons.
    You can now replace text across all code in the workbook.

  3. #3
    2 Star Lounger
    Join Date
    Oct 2001
    Location
    Not in KC anymore
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Edit VB Code (2007)

    That worked.

    I thought I tried that. Hmmm. <img src=/S/stupidme.gif border=0 alt=stupidme width=30 height=30>

    Thanks!

Posting Permissions

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