how to add counter in msgbox to show remain times the message will show vba code

[sspreyer]

hi i have some code that check column c if value 133 enter msgbox pops up but once there is 10 cell fill with 133 the message stop but can also offset this by the values in column f eg if column c has 133 enter 6 times and if a cell in column f has 4 in it this will stop message from pop up what i'm trying to do is show in msgbox remain times the message will appear

here my code:

Please Login or Register  to view this content.

[mikerickson]

Please Login or Register  to view this content.

[sspreyer]

Please Login or Register  to view this content.

thanks have problem getting this to work in my code could show me how i should set this out in the vba code

thanks sorry for being a pain

[mikerickson]

Replace your existing Case 133 code with what I posted.

[sspreyer]

the code you gave me only counts the number times it see 133 show how many more times . i want how many times left eg 133 value shows message until 10 cells are filled in column c so if vba code see 1 cell filled with 133 message box you have 9 remaining "messages "also this code does stops column f from offset number of times message appears for example if column c has 5 cells with 133 value in them and column f has value 2 enter in a cell there would only be 3 messages remaining hope you understand thanks for your help


shane
i have also cross post at http://www.mrexcel.com/forum/excel-q...ions-code.html try help resovle this

[mikerickson]

Have the MsgBox show (11-LngCount) .

[sspreyer]

hi yes that works buts still does not do what, i want. it is cancelling out the formula thats be low

Please Login or Register  to view this content.

thanks

[HaHoBe]

Hi, Shane,

I think you´re wrong about the comparision for lngShow to be -1 because that would show a message with 0 times to come.

Maybe try

Please Login or Register  to view this content.

Ciao,
Holger

[sspreyer]

Hi Holger you were right About

I think you´re wrong about the comparision for lngShow to be -1 because that would show a message with 0 times to come.

yet again you have done it again thank you so much for your help you are :-

*----- legend-----*

thanks

shane