Hello... I need some help... not sure how to do the following:
I have a spreadsheet that contains a drop down list in column B (note only
various rows in Column B contain the drop down list). This drop down list
contains text values example: Level1, Level2, Level3 and LevelZ

When user selects Level1, Level2, or Level3 there is a default rate value
associated to them eg.. Level1 = $10, Level2 = $20 and Level3=$30 but when
the user selects LevelZ then I need an Input Message to pop up asking user to
enter a value... this value will be stored in a cell associated to the LevelZ
for that particular row (note there can be more than 1 for any of the Levels)
but I need the Msg Box to appear every time LevelZ is selected...

So I sort of want Excel to do the following when the condition is (if B3 =
LevelZ and C3=is empty then Message Box appears.... user enters the value and
C3 now contains the value)... keeping in mind that the range could be B8 or
B20 or B55 etc...

I am a Exel basic user... but I do know that Excel is a powerful tool if one
knows how to use it... hope someone can help