Hi Santosh,
Use the following code for combo criteria - Command button 5
Private Sub CommandButton5_Click()
Dim A As Integer
Dim B As Integer
Dim c As Integer
Dim d As String
A = TextBox1.Value
B = TextBox2.Value
d = ComboBox1.Value
c = A * B
If d = "OTHERS" Then
TextBox3.Value = c * 45 / 100
Els
+0530
Subject: $$Excel-Macros$$ combobox criteria not working
From: santoshkumar.subu...@gmail.com
To: excel-macros@googlegroups.com
Hi Friends,
Need a small help.
Attached is a excel with a comand button which will populate a userform.
In the userform there is a comand button called use combo
Hi Friends,
Need a small help.
Attached is a excel with a comand button which will populate a userform.
In the userform there is a comand button called use combo which should
calculate based on the combobox criteria.
This is what not calculating properly.
--
Regards
Santosh
santoshkumar.subu.
