Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Textbox and label formulas-continue
In a userform I would like to have Label17 caption that shows the
value of a formula something like: If ListBox2= H.W.R. THEN TextBox4 - .125 else TextBox4 + .125 How can this be done??? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Textbox and label formulas-continue
I'm not entirely clear about your question, but try something
like If ListBox2.Value = "H W R" Then TextBox4.Text = "-.125" Else TextBox4.Text = "+.125" End If -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "damorrison" wrote in message ups.com... In a userform I would like to have Label17 caption that shows the value of a formula something like: If ListBox2= H.W.R. THEN TextBox4 - .125 else TextBox4 + .125 How can this be done??? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Textbox and label formulas-continue
Private Sub ListBox2_Change() If ListBox2.Value = "H.W.R." Then Label17.Caption = TextBox4.Text - 0.125 Else Label17.Caption = TextBox4.Text + 0.125 End If End Sub -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=521507 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Textbox and label formulas-continue
Thanks Guys ,
This is working great! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking textbox and graphs | Excel Discussion (Misc queries) |