LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 176
Default creating an "inferface-table" into one cell

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






 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Create Pivot Table Data with Column "Sum" rather than "count" defa Johnny_99[_2_] Excel Discussion (Misc queries) 2 January 2nd 10 03:25 PM
creating a "date selector box" or "pull down box" in a cell GaryK Excel Worksheet Functions 2 September 30th 09 01:45 AM
Can you make a cell = 0 if original function is creating a"#ref!"? DaveinNeedofHelp Excel Worksheet Functions 5 April 7th 09 09:42 PM
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell Steve Kay Excel Discussion (Misc queries) 2 August 8th 08 01:54 AM
Complex if test program possible? If "value" "value", paste "value" in another cell? jseabold Excel Discussion (Misc queries) 1 January 30th 06 10:01 PM


All times are GMT +1. The time now is 07:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"