Could do with a hand for a tricky one!!!

[irishmike94]

I am making a rugby management system, using VBA, I have created a userform in order to add player details to a table in excel. I was wondering if it were possible to create a sort of user profile as found in access, with the details entered from the userform for the players that was linked to their name.

Thanks very much

 

[Simon Lloyd]

Just create another worksheet with a dropdown (data validation) in one cell and vlookups in the others, when the name is chosed from the dropdown the vlookups will be populated, there's no need for vba there

 

[Datsmart]

Have you considered using the built-in Excel "Data Form"?

It is a little harder to find in Excel 2007. You will need to add the "Form" icon to the Quick Access Toolbar. See Excel Help and search for "Data Form", it will explain how to set it up.
I copied some of the Help listing here:
The Form button has not been included on the Office Fluent user interface Ribbon, but you can still use it in Office Excel 2007 by adding the Form button to the Quick Access Toolbar.
To add the Form Button to the QAT:
Click the arrow next to the Quick Access Toolbar, and then click More Commands…
In the Choose commands from box, click "Command not in Ribbon" or "All Commands".
In the list box, select the Form button , and then click Add.

To use Data Form, select your table of data and click the Data Form Icon.
There will be options on the UserForm that opens to Edit, Review, Add, or Delete items from your table.

 

[irishmike94]

Thanks for the reply,

Not sure thats what I was thinking about, already have a data entry userform creating in VBA but I was looking for something to serve as a kind of lookup wizard that shows players profiles and information etc.