VBA Solution to Copying Command Buttons and Shapes

Hi there,

Take a look at the attached workbook and see if it does what you need.

It uses the following code:

Please Login or Register  to view this content.

The highlighted values may be altered to suit your own requirements.




I had a look at the code which you're using to display/hide data rows as required. This uses 78 lines of code per set of 11 data rows, and when you multiply that by 250 sets of data rows it amounts to a LOT (19,500 lines) of code to maintain! This is very significant if you ever need to change any of your code, because you're going to have to make those changes in each one of 250 separate locations - doing it is bad enough, but ensuring that it's been done in ALL of those locations is the stuff that nightmares are made of.

The attached version of your workbook uses a modular approach to the VBA, which means that it can process as many sets of data rows as you are ever likely to need, and uses only 107 lines of code in total - not a bad reduction!

The code used is as follows:

Please Login or Register  to view this content.

As before, the highlighted values may be altered to suit your own requirements.



Anyway, hope you find the above useful/interesting - please let me know how you get on.

Regards,

Greg M

Greg M,

Thank you so much! The complete redesign of the code is amazing and way beyond my abilities in VBA at the moment. Thanks again, i will probably be picking parts of this code out to use elsewhere for a long time.

Issues solved, will mark it as such in the post title.

DarkF1ame

Hi again,

Many thanks for your very prompt feedback and also for the Reputation increase - much appreciated

I'm very pleased that I was able to help - it was an interesting project for me.

Please feel free to shout if there's any further information you think I can help you with.

Best regards,

Greg M