Posted to microsoft.public.excel.programming
|
|
difficulty with conversion program
How about replacing the & characters with AND ?
RBS
"saziz" wrote in
message ...
HI All,
I am trying to run this little program. It runs without any problem
apparently, but do not put value in textbox2.
Any help would be appreciated.
Thanks
Syed
If ComboBox1.Value = "KG" & ComboBox2.Value = "Pounds" Then
TextBox2.Value = Format(TextBox1.Value / 2.2046, "00.00")
ElseIf ComboBox1.Value = "Pounds" & ComboBox2.Value = "KG" Then
TextBox2.Value = Format(TextBox1.Value * 2.2046, "00.00")
End If
--
saziz
------------------------------------------------------------------------
saziz's Profile:
http://www.excelforum.com/member.php...fo&userid=6350
View this thread: http://www.excelforum.com/showthread...hreadid=399281
|