how to make only message appear number of time before message does not show

hi everyone thanks for you help in advance

ill try and explains what i'm trying to do best i can ,

i have a piece of vba code that works perfectly if the users enter 133 value in any cell in column c will get message box " have you check asset crib" with yes and no answers what i would like to is add some way if 133 is entered 10 times in any cell in column c to skip the messages and sub completely hope you all understand here my code not sure how to add this i thinking a count function maybe:

Please Login or Register  to view this content.

Originally Posted by JasperD

Hi sspreyer,

the code below does what you're describing.
I also added a line that prevents the code from crashing if you select more than 1 cell to change.

Please Login or Register  to view this content.

Please click the * below if this helps

thanks your legend only thing is if i wanted to add more then 133 for example 122 ,111,123
what best way to do this

cheer

shane

Originally Posted by JasperD

In that case, I would do it like this :

Please Login or Register  to view this content.

Please click the * below if this helps

thanks again legend !!!!!

shane

Originally Posted by JasperD

In that case, I would do it like this :

Please Login or Register  to view this content.

Please click the * below if this helps

hi got another question how could i make this so 133 show message 10 times and 122 show message 6 times and 111 show message 3 times

thanks again sorry for be a pain

shane

bump ! bump