Using information in Combobox in VBA

**rafa_dune** · 11-09-2009, 07:06 AM

hi everyone,

I want to use information ticked in a combobox in my excel spreadsheet using VBA. I.e., if you choose "add" and start the macro then vba add two or more numbers. If you choose "multiply" in the combobox then vba multiply them etc.
Can someone please tell me how to solve this with vba? I would be very thankful!
Cheers,
Rafael

**rwgrietveld** · 11-09-2009, 07:29 AM

Can use this

Code:

Private Sub ComboBox1_Change()
  Select Case ComboBox1.Value
    Case "Multiply"
      TextBox3.Value = TextBox1.Value * TextBox2.Value
      TextBox4.Value = "*"
    Case "Divide"
      TextBox3.Value = TextBox1.Value / TextBox2.Value
      TextBox4.Value = "/"
    Case "Add"
      TextBox3.Value = TextBox1.Value + TextBox2.Value
      TextBox4.Value = "+"
    Case Else
    '
  End Select

End Sub

Private Sub Worksheet_Activate()
  ComboBox1.AddItem "Multiply"
  ComboBox1.AddItem "Divide"
  ComboBox1.AddItem "Add"
End Sub

Thread: Using information in Combobox in VBA

Thread Tools

Rate This Thread

Display

Using information in Combobox in VBA

Re: Using information in Combobox in VBA

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions