How to enter a specified digits in a cell if another cell has a certain text

[shadab841]

Brand	Shipment Code
PH	7 digits
PC	8 digits

Okay!
PH and PC are two brands in my logistics organisation,
the thing is the shipment code of PH is 7 digits and PC is 8 digits
what I want is when i enter PH the shipment code should only be 7 digits if its more than that then it should display me an error!!
(May be this could be done through Data Validation)

Please help me if you can!

Thanks!

 

[Fluff]

I think the only way would be VBA.

 

[shadab841]

Can you guide me some courses to learn vba for beginners?

 

[Fluff]

I'm afraid not, I've never been on a course so have no idea what courses are available, or how good they are.