Forms,dialog boxes with lables.

[Guest]

Hi all.....

I don't know very much VB in excel. Please help me in this regard.

Iam working in a Private company, My profile is to bring the data item in a
file that matches our data item policies. We will give one code to different
items based on the policy. I want a excel form that, which i give any data
item(like "allowance" the policy is "we can take this item as ADA") in text
box, the comment appeares the below which is the policy("we can take this
item as ADA")

If I enter any item in text box, the related comment should be desplayed
under the text box. I have the 120 different data items which I often
confuse to follow the different policies.
Please help in this regard...

I will be very thankful to you people..

Thanks
Narendar
Research Analyst.

 

[Guest]

I sound like you should use a worksheet_change function. entering data in
any cell can tricker the macro to do any excel functions. The macro can
perform a lookup and enter the data in a diffferent cell.