Using a combobox to select sheet where data is to be copied from a userform

**Ceeseven** · 02-06-2009, 11:43 AM

Before I describe my problem. I have to say this forum is awesome. I first started browsing as a guest and learned a lot. When I got into my current jam, I decided to register a few days ago and ask for help. I have since tried searching keywords for help but no luck. So here goes my first post.

The macro below in its current state adds data entered from the userform to a specific sheet. I would like to change it so that a player can be selected from combobox named txtmplayer and the data entered be copied to that specific players sheet.

If this information is vital: There are 8 players. Player sheets can be named player1, player2, and so on. I would like to keep same method for entry (finds first available row)

Thanks in advance for any help.

-Chris

Please Login or Register  to view this content.

**royUK** · 02-06-2009, 11:48 AM

Attach the workbook.

**Ceeseven** · 02-06-2009, 01:14 PM

as requested.

thanks.

**royUK** · 02-06-2009, 01:28 PM

hy have you renamed the Comobox control to start with txt/ It's normal practise to choose a name that helps identify the control, so I wold use cbo to denote a ComboBox and player, eg. cboPlayer

Please Login or Register  to view this content.

**Ceeseven** · 02-06-2009, 01:37 PM

yes
when i first started with vba i got into that bad habit
list, combo and text boxes in that macro are all named txt something
sorry

**Ceeseven** · 02-06-2009, 01:40 PM

I answered your question without even noticing the corrected code.

Thank you for the help. And in the future i will use the norm when it comes to naming to make help easier. Thanks again,
-Chris