Drop-down menu options

I'm sorry, I'm not quite sure I understand. What should happen using this code?

I tried copying and pasting, however, I didn't know what was supposed to happen so I couldn't test it.

Maybe another example that would help (I'm not sure if I'm explaining myself clearly) would be to have a single cell with a drop-down of multiple items and one of the options would be "Other..." and when "Other..." is selected, you are prompted to input what that value should be.

I know how to create the menu, however, I'm trying to make this as simple as possible for those that will be filling it out.

Thanks.

Not sure what you mean by bumping - folks who know an answer always feel free to jump in at any
point.

Contact me privately deitbe at consumer dot org, and I will send you a working example of the
code that I posted. When you enter the value "Flat Fee" into cell B3, an input box will pop up
asking for the rate, which would then be entered into cell C3.

HTH,
Bernie
MS Excel MVP


"conksu" <conksu.26xp9g_1146160340.7292@excelforum-nospam.com> wrote in message
news:conksu.26xp9g_1146160340.7292@excelforum-nospam.com...
>
> Is bumping frowned upon?
>
>
> --
> conksu
> ------------------------------------------------------------------------
> conksu's Profile: http://www.excelforum.com/member.php...o&userid=31870
> View this thread: http://www.excelforum.com/showthread...hreadid=536790
>