Output to a cell (Excel)

[señorbadger]

Hi i have a form where the user enters data i am using the VB toolbox

How can i make this export to a cell such as H8 here is some code i am using for example

dim stockamnt as integer
 stockamnt = Val(TxtNoin.Text) 'textbox to enter stock level
  stockamnt = stockamnt - 1 ' decrease level by one
  TxtPrice.Text = stockamnt 'set textbox value to varible
       ' i need code here to place the value of stockamnt to a cell

Keep the code simple please cos i know little VBA


Thanks all
Sam Lad

[ZeBula]

dim stockamnt as integer
stockamnt = Val(TxtNoin.Text) 'textbox to enter stock level
stockamnt = stockamnt - 1 ' decrease level by one
TxtPrice.Text = stockamnt 'set textbox value to varible
' i need code here to place the value of stockamnt to a cell


' code:

Cells(lRow, lColumn).Value = txtPrice.Text

' this will assign the value in txtPrice to the cell given the row, and column coordinates


ZeBula

[señorbadger]

Cells(8, H).Value = TxtPrice.Text

Causes a error which is

[si_the_geek]

you need to use the column Number, not the name.

so H8 is:
Cells(8, 8).Value = TxtPrice.Text

and H9 is:
Cells(9, 8).Value = TxtPrice.Text