Data from userform to worksheet

[koala]

Hello forum,

Can someone point me in the right direction with this.

I have designed a userform for data entry.

It has a combobox that is linked to a pre defined range on th
worksheet (A59:A94) called "Plant_Types"

There is then 8 text boxes for the user to enter the values int
(numbers). On the worksheet this data goes to the next 8 columns (B:I)
rows 59:94 depending on the combobox selection. Ie. If the combobo
selection is for the entry in cell A75, the data needs to go int
B75:I75.

How do I then get that data to the worksheet?

Also if the combobox selection has corresponding data in the outpu
cells already (B:I), can that data be loaded to the form so the user i
able to see it when the selection is made from the combobox, an
therfore hopefully not overwrite it?

Thank you in advance for your assistance

cheers
Koal

 

[Mike Fogleman]

It sounds like you are trying to re-invent Excel's built-in Data Form. Look
into that for doing what you want. I have a workbook that does this with
several different data form's to keep a database of different categories of
items. These data forms are displayed by selecting a custom menu item that
is added to the menu bar next to Help (you can position it wherever). If you
would like to see if what I have could be adapted for your use, email me
and I will send you a copy and help you with adapting it.

Mike F