Userform Combobox - Put data in cells according to selection

[ExtraCheese]

I have an userform with two Comboboxes and a textbox. Combobox1 has a string of time slots. The selection of combobox1 should define in which row the data from textbox1 is put.
Combobox2 is populated by the same text as columns B to I, the selection should define in which column the data from textbox1 is put.

I can't find the answer to my problem anywhere... is this possible in Excel?

Simplified example of how my sheet looks like:

	Action
Time	Task A	Task B	Task C	Task D	Task E
22:00 - 23:00
23:00 - 0:00
0:00 - 1:00
1:00 - 2:00
2:00 - 3:00
3:00 - 4:00
4:00 - 5:00
5:00 - 6:00

 

[dmt32]

Hi,
you can use the ListIndex property of the controls

example

Private Sub CommandButton1_Click()
    Dim RecordRow As Long, RecordColumn As Long
    
    RecordRow = Me.ComboBox1.ListIndex + 3
    RecordColumn = Me.ComboBox2.ListIndex + 2
    
    Cells(RecordRow, RecordColumn).Value = Me.TextBox1.Value
    
End Sub

This assumes the lists in the controls are in same order as your worksheet

Dave

 

[ExtraCheese]

This works perfectly, thanks a lot!

 

[dmt32]

This works perfectly, thanks a lot!

welcome glad suggestion helped - appreciate your feedback

Dave