Update Log VBA

[leewoo5]

Hi all,

I have created a form on Excel that once filled in I would like a log with some of the cell values to be populated on a separate worksheet. Does anybody know where I would start with such a thing? I am happy to share the workbook if required...

Many thanks,

 

[ranman256]

once you have your form and text boxes, user would typically click a button to post the data,
the button click event would be like:

sub btnSave_click()
sheets("Log").select
activecell.offset(0,1).value = txtBox1
activecell.offset(0,2).value = txtBox2
activecell.offset(0,3).value = txtBox3

activecell.offset(1,0).select    'move to next row

clearBoxes
end sub

sub clearBoxes()
  txtBox1 = ""
  txtBox2 = ""
  txtBox3= ""
end sub