Excel warning with VBA 1

[kabushnell]

I have a worksheet in Excel that contains an ID # and following each ID there is a dollar amount entered each month. Similar to the following:

ID Total Jan Feb Mar
8603 200 125 50 25

There can be the same ID several times. Basically what I have is that no single ID total can be greater than 700, and no ID total can be over 1400. I have formulas written that total each row and then again for the total ID. What I was wondering is if there is a way to have Excel pop up an error when someone enters an amount in one of the months that brings that particular ID over the 700 or 1400 limit?

I hope that isn't to confusing. Right now we have to enter the amounts each month and then go see if anyone has gone over the limits. Any help is greatly appreciated.

 

[xlbo]

Bowers - doesn't work for me - what version of excel are you running ??
I'm on 2002 SP1

Rgds, Geoff
Quantum materiae materietur marmota monax si marmota monax materiam possit materiari?
Want the best answers to your questions ? faq222-2244

 

[Bowers74]

xlbo - so am I!

Enter a value that causes an error, click Retry and then select a different cell.

That's what I'm doing.

By the way, Remember what we discussed earlier this week about not being appreciated? :-(

If you can't be "The Best", be the best at what you can!!!

Never say Never!!!
Nothing is impossible!!!

 

[TonyJollans]

Hi Bowers,

Thanks for pointing me here from the other thread. I have had a play with this and learnt a fair deal. Have a star.

On the User being able to get round the validation, the behaviour seems inconsistent and I can't work out why sometimes it lets me do it and most of the time it doesn't.

Enjoy,
Tony