Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Hello I know this probably is a easy task to most of you but i'm quite a new excel user. here it goes: I would like to create a sheet or a row with two or three cells where the user can enter data (coordinates). (A text on the sheet says for instance "Input point 1". Then, by pushing a button (marked "add" or something like that) , the data in the sheet or row should be added to a table and the cells in the sheet should be cleared so that the user can "Input point 2" - "add" - the second row in the table is added.... and so on until the user is done and presses the "End" button. (The amount of points is not set from the start, instead they are added to the table until the user has no more points to add). The coordinates in the table will later be used to draw a chart... but I think I can handle that myself. I don't know if this is bast done in macro or something, as I wrote I'm just a beginner at this.:( Thanx to all of you who tries to help me with this, and sorry for my bad English. Best regards, W -- Borgas ------------------------------------------------------------------------ Borgas's Profile: http://www.excelforum.com/member.php...o&userid=28660 View this thread: http://www.excelforum.com/showthread...hreadid=553078 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Filling only cells for rows with content | Excel Worksheet Functions | |||
Adding a constant to a formula. Problems w/filling in | Excel Worksheet Functions | |||
adding content to a cell | Excel Programming | |||
Automatically filling in cells based on another cell's content | Excel Worksheet Functions | |||
Filling a cell based on the content of another cell | Excel Programming |