Using a ListBox to enter data into specific cells help please!!!!!

[Wasim Iqbal]

I have coursework to do and I have hit a brick wall. I need a code that inputs data into certain cells when a selection is made from a ListBox.
For example, In the ListBox I will have name of events, such as

Girls swimming competition

Boys swimming competition

When I select Girls swimming competition I want the data I typed in the Textboxes to go into the cells which are part of the Girl swimming competition table on the sheet. Then when I select Boys swimming competition I want the data I typed in the Textboxes to go into the cells which are part of the boys swimming competition table on the sheet.

[k64]

Post a sample workbook with an example of what you want to happen.

[Wasim Iqbal]

Post a sample workbook with an example of what you want to happen.

I have managed to do it it is okay now. Thank you anyway!

[k64]

Glad it worked out for you. Feel free to share what you did.

[Wasim Iqbal]

Glad it worked out for you. Feel free to share what you did.

If Me.ComboBoxName.Value = "Whatever" Then Worksheets("SheetName").Range("A1").Value = Me.SomeTextBoxName.Text
End If

I used this code to make my form enter data into certain cells based on combo box selection.