Proper syntax to shorten and speed up code

Hi guys,

Mitch here! really hoping to get some help with an extremely simple piece of coding.

I am fairly new to this as you can probably tell from my poor first attempt at the coding. Its extremely simple, and just requires certain data to show when specific a option is chosen from a choice of option tabs/buttons.

Due to the length of the code, it is very slow. I have tried all different methods of shortening the code but to no avail!

Any help on this would be very welcome.

coding is as follows and is fairly laughable compared to the level I have seen on here!

Please Login or Register  to view this content.

This carries on approx. 20 more lines for another 2 option buttons hence the slow update when choosing the options...

I have tried entering the range as "B60:B70" but the sheet doesn't react and update the data.

I have also tried 'Dim' but due to my rookie level can't seem to get it to work.

As I have mentioned, I would love some sort of help!

Perhaps some day I will be giving advice on here but at the moment, this seems unlikely!



Thank you in advance...

Mitch

Hi, Mitch,

getting it together instead of calling each single cell fully qualified:

Please Login or Register  to view this content.

Ciao,
Holger

Please Login or Register  to view this content.

Regards, TMS