Procedure too large

Hello all

I have a procedure which is run from a click of a button, in this instance a continue button

It is a long piece of code and there is still more to come.

Can anybody help me shorten this code as I cannot understand how to shorten it myself.

I know this is probably too much too ask, but I really struggling as I am a bit of a novice when it comes to VBA.

I have added the code as it is a .txt file as it is too large to past onto here!

Many thanks in advance.

*Frightening*

AS you have discreet blocks for various carriers and services and most of the data seems to be static for each block, you could do something like...

Please Login or Register  to view this content.

That reduces the code from 180+ lines to 48 (or so) for the first block alone.

Add corresponding procedures for each block of code.

Hi

Thank you for this.

I will have a look and respond if it works, which I am sure it will

Yes it is frightening

...and respond if it works

And if it doesn't work... just going to forget about it?

Many thanks Cytop

This has worked wonders. I am now using it in other places to tidy up my scripts. So thank you very very much