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
VB Code:
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





Reply With Quote