koala
10-08-2004, 08:44 PM
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 the worksheet (A59:A94) called "Plant_Types"
There is then 8 text boxes for the user to enter the values into (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 combobox selection is for the entry in cell A75, the data needs to go into B75:I75.
How do I then get that data to the worksheet?
Also if the combobox selection has corresponding data in the output cells already (B:I), can that data be loaded to the form so the user is able to see it when the selection is made from the combobox, and therfore hopefully not overwrite it?
This is part of a large data entry form, where the data goes to completely different areas on the worksheet, however I can modify/replicate the code to suit the other areas. The built in data entry form, whislt is ok for one section, does not have enough flexibility to cover the entire userform.
Thank you in advance for your assistance
cheers
Koala
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 the worksheet (A59:A94) called "Plant_Types"
There is then 8 text boxes for the user to enter the values into (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 combobox selection is for the entry in cell A75, the data needs to go into B75:I75.
How do I then get that data to the worksheet?
Also if the combobox selection has corresponding data in the output cells already (B:I), can that data be loaded to the form so the user is able to see it when the selection is made from the combobox, and therfore hopefully not overwrite it?
This is part of a large data entry form, where the data goes to completely different areas on the worksheet, however I can modify/replicate the code to suit the other areas. The built in data entry form, whislt is ok for one section, does not have enough flexibility to cover the entire userform.
Thank you in advance for your assistance
cheers
Koala