Hi im new to vb and Excel
Im tring to create a form that you can type a value in a text box and it
saves it in a seperate sheet, on a specific column in the workbook

What I have so far is a button and text box, And a name range(scraprng)that
is column q thru row 365


-------------------------------------------------------------------

Private Sub CommandButton1_Click()

Worksheets("OEE Data").Range("scraprng") = scraptxtbox

--------------------------------------------------------------------
say i type a value into the text box and hit the button, it will save the
value in the column , but in all the cells in the namerange

What I want it to do is save the value in only one cell at a time in the
namerange per button click

--
Thanks