help with excel

Question

I can’t figure out how to make this happen. i have a user form created in excel. i have radio buttons, drop down lists and a text box on the userform. for example: if in the drop down list I choose “a customer called” and in the radio buttons I picked “to schedule an appointment.” and “wants a call back” I want the text box to now show “the customer called to schedule and appointment. wants a call back” basically I need the selected drop down list and radio buttons to mirror into the text box to create a comment with the selected options.

Answer 1

If you are using VBA your code would look something like this:

Private Sub ListBox1_Click()

   TextBox1.Value = ListBox1.Text

End Sub

Private Sub OptionButton1_Click()

   SetTextbox

End Sub

Private Sub OptionButton2_Click()

   SetTextbox

End Sub

Private Sub SetTextbox()

   If OptionButton1.Value = False And OptionButton2.Value = False Then

       TextBox1.Value = " "

   ElseIf OptionButton2.Value = False Then

       TextBox1.Value = ListBox1.Text & " to schedule an appointment"

   Else

       TextBox1.Value = ListBox1.Text & " and wants a call back"

   End If

End Sub

Private Sub TextBox1_Change()

End Sub

Private Sub UserForm_Initialize()

   ListBox1.AddItem "A"

   ListBox1.AddItem "B"

   ListBox1.AddItem "C"

   ListBox1.AddItem "A customer called"

End Sub

If you are just adding a list, radio buttons, and textbox on a worksheet your formula would look something like this: =A1&" "&IF(B1=1,+A4,IF(B1=2," and " &A6))

A1 = cell with list

B1= cell with assigned radio button (with value 1 or 2)

A4= cell with text “to schedule an appointment”

A6= cell with text “wants a call back”

A7 = A1&" "&IF(B1=1,+A4,IF(B1=2," and " &A6))

Link text box by clicking on it to activate it then in the formula box type =$A$7

Hope that helps

Answer 2

I haven't used this much, but just opened Excel, and chose Drop Down Tutorial box in green outline, and followed the quick training to create a drop down list. I'll bet you can figure it out from here.