one user form multiples worksheets
 

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

one user form multiples worksheets
 

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




On Dec 11, 10:22*pm, celio3c
wrote:
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