difficulty with conversion program

[saziz]

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

[RB Smissaert]

How about replacing the & characters with AND ?

RBS


"saziz" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[saziz]

Thanks RBS That worked.
Syed