Fill a cell via textbox according to combobox selection

Hi everyone,

Pb 1: I have a userform with 1 combobox and 2 textbox. (The combo box is populated with a dynamic range). I would like to be able to select an option from the combobox and when I click the command button the info in the textbox will be placed into the sheet in the same row as the selected combobox word. For example. The combo box has a list of months-year, I want to select a "Jun-12", enter info into textbox1 and tectbox2, click the button "enter" and have the info placed into a cell on the column belongs to the month. ("Jun-12" on cell D27, so text1 on the cell D28 and text2 on the cell D29)


Pb 2 : Textbox6 -> it belongs to comments, but if there is already a comment on the sheet "interne Supplier PPM". For a new comment, i want to insert a new range in order to write the new one and the older one goes below to the new one.


Any help would be appreciated

Thanks for ur prgm, but i got a small issue:

My pb is Combobox should take the values from these range("C26:F26"). First issue, he shows only the value from C26. the second issue is :in your prgm, you select Col "D" & l. but what i want is tht it should select C26 or D26 or E26 or F26.

Please Login or Register  to view this content.

Pb 2: Comments are located in the range("V11:AA30"). so the range is limited.

Thanks Xero Solus for ur solution, but i came back to my initial pb:
Once the month is selected by the ComboBox4 (if month belongs to cell D26), I want to copy the data from TextBox4 to cell D27 and from Textbox5 to Cell D28.

CHeck the pgm part 'Last evolution' (not working)

Please Login or Register  to view this content.

But my second issues has been solved, thank you for that!

Please Login or Register  to view this content.