HELPPP!!! Excel-> COMBO AND TEXT BOX

[eliking510]

heyy <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
I have a userform , with a combobox that contains all the monthes of year, and also 12 sheets , each for a month.<o></o>
(two textboxes below the cmbobox)<o></o>
<o></o>
What I want to do is = when i choose a month from the combobox , and type into the textboxes , the text will be copied into the corresponding sheet<o></o>
--------------------------------------------------------------------------------<o></o>
<o></o>
1
http://img641.imageshack.us/i/85856834.png/<o></o>
<o></o>
2<o></o>
http://img138.imageshack.us/i/56460260.png/<o></o>
<o></o>
3<o></o>
http://img232.imageshack.us/i/75217580.png/<o></o>
<o></o>
4<o></o>
http://img340.imageshack.us/i/98646498.png/<o></o>
<o></o>
------------------------------------------------------------------<o></o>
<o></o>
<o></o>
Thank You !!<o></o>

 

[Andrew Poulsom]

Welcome to MrExcel.

Add a CommandButton to your UserForm. Sample code:

Private Sub CommandButton1_Click()
    Dim NextCell As Range
    With Worksheets(ComboBox1.Value)
        Set NextCell = .Cells(.Rows.Count, 1).End(xlUp).Offset(1)
        With NextCell
            .Value = TextBox1.Value
            .Offset(, 1).Value = TextBox2.Value
        End With
    End With
End Sub

 

[eliking510]

Thank you very much !!! it works