How to combine vba routines?

**nmsmith** · 05-15-2015, 12:53 AM

Hey guys I'm coding a few things on a single sheet but im not sure how to combine more that one routine into a sheet. So far I have these:

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

They both work separately really well so not sure how to get them to play nicely ive tried putting them under the same Private Sub and then in their own but i get problems each time.
Note: some of the cell values will be changed when i put it into the sheets vba

Nick :D

**Trebor76** · 05-15-2015, 01:08 AM

Hi Nick,

Perhaps like this:

Please Login or Register  to view this content.

Regards,

Robert

**nmsmith** · 05-15-2015, 01:16 AM

Ok so that worked, though I have another piece of code which is very similar to the first set, If i were to add it on as well how would i go about doing that? would it be the same process?

**nmsmith** · 05-15-2015, 01:32 AM

I have this but it doesnt work with the last routine in it, it works with the first two in it.

Please Login or Register  to view this content.

Thanks
Nick

**Trebor76** · 05-15-2015, 01:33 AM

Hard to say - if you want add another data validation for when a cell changes you could add another ElseIf statement??

**nmsmith** · 05-15-2015, 01:39 AM

My sheet coding is disappearing when i close a spreadsheet and reopen it :/

**Trebor76** · 05-15-2015, 02:21 AM

My sheet coding is disappearing when i close a spreadsheet and reopen it

Though this has nothing to with your original question - make sure you save the file as a Excel Macro-Enabled Workbook so that its extension is xlsm. Not sure apart from that.

**humdingaling** · 05-15-2015, 02:54 AM

hey nick
your 1st code has 8 cases but the last has 10

how many did you actually want?

**nmsmith** · 05-18-2015, 02:31 AM

Well there would be a total of 18 cases but 8 of them are constrained by B20 and the other 10 are constrianed by B34 i believe. Is it Not possible to have more than one??

**humdingaling** · 05-18-2015, 02:52 AM

ok i see the difference

you can just peg another elseif at the bottom as the trigger is a different target address

as this new sheet is different to the other ones you provided in the other posts
however can you not just shorten them the same way with the code i gave you?
as you dont really need to have so many cases...you just need to increment it based on the DV right?

**nmsmith** · 05-19-2015, 07:38 AM

Hey thanks ill try adding another elseif in there and see how it goes, and yeah probably dont need all these cases but i still am not really sure how that code you supplied earlier works. for now im happy with having a bunch of cases, it just needs to work.

Thanks
Nick

**humdingaling** · 05-19-2015, 08:24 PM

Hi Nick

i wrote an a good chunk of notes for you in the coding to help you try to understand it
as you said, the case code works for you and if your happy with it then there is no need to rack you brain around learning it

it is mainly algebra at work but should you want to learn it for the future it is broken down for you

Cheers
Hum