Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert the value from an input box
Hi, i need to insert a value into a cell in a different worksheet to the
one that i am working in. I need to start at A1 and go down to the end of the list and insert the input box value in the next empty space. Could somebody please help with some code, thanks in advance. Tempy *** Sent via Developersdex http://www.developersdex.com *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert the value from an input box
something akin to ans = Inputbox(value) With worksheets("Sheet2") .Cells(.Cells(Rows.Count,"A").End(xlUp).Row+1,"A") .Value = ans End With -- HTH Bob Phillips "Tempy" wrote in message ... Hi, i need to insert a value into a cell in a different worksheet to the one that i am working in. I need to start at A1 and go down to the end of the list and insert the input box value in the next empty space. Could somebody please help with some code, thanks in advance. Tempy *** Sent via Developersdex http://www.developersdex.com *** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert the value from an input box
Thanks Bob, your help is appreciated as always.
Tempy *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
insert colons in time automatically when input to cell | Excel Worksheet Functions | |||
How do I add input data in the input ranges in drop down boxes. | Excel Discussion (Misc queries) | |||
=SUMIF(Input!H2:H718,AZ19,Input!E2:E685)AND(IF | Excel Worksheet Functions | |||
insert data into macro code from text input field? | Excel Programming | |||
CODE to select range based on User Input or Value of Input Field | Excel Programming |