one user form multiples worksheets

  • Thread starter Thread starter celio3c
  • Start date Start date
C

celio3c

i'm loking for to write a code that allows me to use one user form to enter
data in multiples working sheets, the fields names will be all the same in
all sheets as well the kind of data, the code would place the information on
a destination sheet indexed to a selection from a combo box ( on the form 'f
course) wich contains all the sheets names. the combo box also would allow me
to create a new work sheet for a new set of information. can anybody give a
hand on that?

I apreciate all the help.

celio3c
 
for example, a userform with a button that says "ok" when you're done
entering information:

sub cmdok_click()
dim myWorksheet as worksheet

set myWorksheet = me.combobox1.value

myWorksheet.range("a1").value = me.txtName.value
myWorksheet.range("b1").value = me.txtAddress.value

End Sub

not tested, but hope it gives you an idea to get you started.
:)
susan
 
Back
Top