Display Relative Message Next To Cells

  • I have a LARGE list of items in rows with a quantity column next to them. I want to be able to popup a message box when the user enters a numeric quantity in the quantity column. There will be numerous messages for different rows.


    Example


    Column A = quantity
    Column B = Description
    Column C = Part Number
    Rows 3-1500 have different items


    Rows 8-15 will have the same message for the parts - "This item requires adaptor"
    Rows 29-172 will have the same message for the parts - "This item comes in a qty of 2"
    Rows 723-812 will have the same message for the parts - "Please choose appropriate bolt"


    Thanks for your help!

  • Re: Display Message Box When Number Entered In Certain Cell


    Why not just put comments in the cells, or use data validation to show an input message when the cell is selected?

    [SIZE=1]Entia non sunt multiplicanda sine necessitate.[/SIZE]

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!