Extending a Private Sub Worksheet?

Hi Guys,

First I would like to thank you in advance- I know what a help this forum is and it has come to my rescue more times than I have had hot baths.

I am trying to use a macro on my excel sheet. And that lies my problem as I am relatively inexperienced with VBA.

My question- I have used a macro from this site http://excel.tips.net/T003283_Hiding...ell_Value.html) and adapted it for my sheet. See below)

Please Login or Register  to view this content.

I would like to add another instance of this (see below)

Please Login or Register  to view this content.

But when I paste it below it - it wont work?

Apologies for being ultra new!

Thanks in advance

Hernan

It's an Event macro so it needs to be in a Sheet Class module (the sheet where the selection/changes happen), NOT a standard module. Where have you pasted it?


Regards, TMS

Please Login or Register  to view this content.

Regards, TMS

Hi, and welcome to the forum,

Unfortunately your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Since this is your first post, on this occasion I'll change it for you, but please note for the future.

All the sheet events, like the Selection_Change events you mention are 'inbuilt'. i.e. they're not macro code which you can treat like any other procedure you want to write. There is only one Selection_Change event and therefore you need to include all your code within the single procedure.

Please Login or Register  to view this content.

Thanks for the rep.


If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save