Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Mario,
You could use a userform to allow a user to enter numbers into a text box that are then summed with the sum placed into the cell. Would that work? Otherwise, just have the user start type =100+20-15-10 and Excel will evaluate the formula that results to show 95. HTH, Bernie MS Excel MVP "Mario" wrote in message y.telekom.at... hmm the perfect solution would be that if u do doubble click on B3 a "new-small-tiny-excel" opens and that u can type in there A 1 100 2 20 3 -10 4 -15 and that B3 than has the vaule 95 the problem is that tere could be 20-30 of these B-fields so a connection to another table is tooo complicate u understand the problem? kind regards mario |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Create Pivot Table Data with Column "Sum" rather than "count" defa | Excel Discussion (Misc queries) | |||
creating a "date selector box" or "pull down box" in a cell | Excel Worksheet Functions | |||
Can you make a cell = 0 if original function is creating a"#ref!"? | Excel Worksheet Functions | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) |