| 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 |
| 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 | |||
Threaded Mode
