Adding/Deleting Code from a Sub via Macros

[Since1817]

Is there a way that I can create a macro to add to/delete code from a previous sub I have created? I am currently attempting to add/remove accounts (worksheets) from a workbook, but the code I am using for interest distributions to each account needs to be updated with each change.

When an interest distribution happens, money is allocated (based on percentages and the cash amount entered in a userform) to investors in each account (worksheet) and I would need to add a few lines to the code in the already completed sub for the interest distribution each time a new account is created to make sure the distribution includes the created account.

If there is any information that is necessary to help me with this, just let me know. I can post bits of my code and what I need entered. In general though, my question is simply: Can you change code in a sub via another sub? If so, how?

[dominicb]

Good evening Since1817

...and welcome to the forum!!

In general though, my question is simply: Can you change code in a sub via another sub? If so, how?

You can. You haven't given much information about your situation though. Are you wanting to change / amend code in a standard sub, or is it an event procedure? is there a userform involved?

I would recommend you have a look at this article here, but a word of warning - I don't think that this particular part of VBA is well suited for beginners.

HTH

DominicB

[Since1817]

Thanks for the welcome! I expected this part to be a bit beyond what I know how to do, which is why I'm enlisting your help here .

Here's a better idea of what I have and what I don't know how to do:

What I have:

An interest distribution user form. There's two text boxes, with one being for the value and one being for the date. Upon clicking the "Finish" button a sub is run that distributes the value/date to every account within the workbook based on percentages located within the sheets.

The code looks like this (probably a better way to do a lot of what I've done, but it works):

Please Login or Register  to view this content.

There's one of these for each account in each sheet.

What I need to figure out:

I want to be able to add worksheets and accounts by creating a sub that edits my initial one. Within this edit, I would need to create new variables for the sheet (PMasterVinton is an example of the main variable, a percentage, used for each account in that specific sheet. PVinton10 is the variable, also a percentage, used specifically for a certain account in the worksheet) as well as put an extra set of the above code (with new columns and variables of course) in there.

Similarly, I need to figure out how to delete sections of it for when a user wants to delete worksheets/accounts. I would imagine this would be much easier than the additions, but I could be wrong.

I'm not asking for you to write this for me of course (I'm trying to learn this!), but right now I'm not sure where to start. Any suggestions are welcome!

EDIT: I also had a chance to read through that link you provided Dominic. It didn't provide much as to how to edit a previous procedure, rather just how to delete and add a whole new sub on its own via code. It did, however, teach me how to locate text within a sub which will help me when I get to that point. As it stands now though, I still have no idea what code I would need to even initiate a change/edit to a previous sub .

[Since1817]

Anyone with any ideas at all?