Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return a formula
Is there any way to force this to be a formula when it is placed in cell B3?
I want someone to be able to enter say 10 + 10 and have the result be 20 in cell B3. I know you can enter =10+10 and it will return 20, but I can not count on everyone remembering (knowing to use) the = sign. Private Sub TextBox80_Exit(ByVal Cancel As MSForms.ReturnBoolean) Worksheets("Income").Range("B3").Value = TextBox80.Value End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return a formula
i changed it up because i don't have your code, but this worked for me when i
clicked a commandbutton on the form after entering 10+10 into textbox1 Private Sub CommandButton1_Click() Worksheets("Sheet2").Range("B3").Formula = "=" & UserForm1.TextBox1.Value End Sub -- Gary "Patrick Simonds" wrote in message ... Is there any way to force this to be a formula when it is placed in cell B3? I want someone to be able to enter say 10 + 10 and have the result be 20 in cell B3. I know you can enter =10+10 and it will return 20, but I can not count on everyone remembering (knowing to use) the = sign. Private Sub TextBox80_Exit(ByVal Cancel As MSForms.ReturnBoolean) Worksheets("Income").Range("B3").Value = TextBox80.Value End Sub |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return a formula
Thanks.
This is how the finished code looked: Worksheets("Income").Range("B3").Formula = "=" & TextBox80.Value "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... i changed it up because i don't have your code, but this worked for me when i clicked a commandbutton on the form after entering 10+10 into textbox1 Private Sub CommandButton1_Click() Worksheets("Sheet2").Range("B3").Formula = "=" & UserForm1.TextBox1.Value End Sub -- Gary "Patrick Simonds" wrote in message ... Is there any way to force this to be a formula when it is placed in cell B3? I want someone to be able to enter say 10 + 10 and have the result be 20 in cell B3. I know you can enter =10+10 and it will return 20, but I can not count on everyone remembering (knowing to use) the = sign. Private Sub TextBox80_Exit(ByVal Cancel As MSForms.ReturnBoolean) Worksheets("Income").Range("B3").Value = TextBox80.Value End Sub |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return a formula
glad you got it working.
-- Gary "Patrick Simonds" wrote in message ... Thanks. This is how the finished code looked: Worksheets("Income").Range("B3").Formula = "=" & TextBox80.Value "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... i changed it up because i don't have your code, but this worked for me when i clicked a commandbutton on the form after entering 10+10 into textbox1 Private Sub CommandButton1_Click() Worksheets("Sheet2").Range("B3").Formula = "=" & UserForm1.TextBox1.Value End Sub -- Gary "Patrick Simonds" wrote in message ... Is there any way to force this to be a formula when it is placed in cell B3? I want someone to be able to enter say 10 + 10 and have the result be 20 in cell B3. I know you can enter =10+10 and it will return 20, but I can not count on everyone remembering (knowing to use) the = sign. Private Sub TextBox80_Exit(ByVal Cancel As MSForms.ReturnBoolean) Worksheets("Income").Range("B3").Value = TextBox80.Value End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return Formula | Excel Worksheet Functions | |||
if formula return | Excel Discussion (Misc queries) | |||
Formula to Return Last Non-Zero Value in Row | Excel Worksheet Functions | |||
Why does my formula return zero? | Excel Discussion (Misc queries) | |||
Date formula...help with return on formula | Excel Worksheet Functions |