View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
RB Smissaert RB Smissaert is offline
external usenet poster
 
Posts: 2,452
Default 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