consksu,

You could use the worksheet's change event: copy the code below, right click the sheet tab, select
"View Code" and paste the code in the window that appears.

This is written for a single cell (B3, putting the rate into C3), but could easily be re-written for
multiple cells.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$B$3" Then
If UCase(Target.Value) = "FLAT FEE" Then
Application.EnableEvents = False
Range("C3").Value = Application.InputBox("Enter your fee rate", , , , , , , 1)
Application.EnableEvents = True
End If
End If
End Sub

HTH,
Bernie
MS Excel MVP


"conksu" <conksu.26xf2m_1146147003.5146@excelforum-nospam.com> wrote in message
news:conksu.26xf2m_1146147003.5146@excelforum-nospam.com...
>
> Hi,
> I am creating an excel sheet with drop down menus in different cells,
> however, I would like to have one option where it would automatically
> prompt for text entry. For example, one question is asking whether you
> charge a fee based on a call or whether if it is a flat fee. If the
> person chooses "Flat fee", I would like it to allow the person to enter
> the value of the fee. If it could be some kind of seperate prompt
> dialog, that would be ideal.
>
> Thanks!
>
>
> --
> conksu
> ------------------------------------------------------------------------
> conksu's Profile: http://www.excelforum.com/member.php...o&userid=31870
> View this thread: http://www.excelforum.com/showthread...hreadid=536790
>