Hi Captngnvr,

Take a look at Debra Dalgleish's site and check out all the info
on Data Validation.
http://www.contextures.com/tiptech.html

Also you may be able to utilise the comments function in Excel.

To be honest it sounds like you really should be redesigning your
worksheets to make them (much) more user friendly. What you are
attempting to do still sounds like a recipe for disaster to me.

HTH
Martin