VBA Help!!

Hey guys I am new here, but I need some help with VBA.

I'm not very good at VBA, but I'm trying to learn it on the go.

I've created an excel spreadsheet with players projections. I took MLB players stats from the past 2 years and ive created a formula to come up with the projections. (I'm a baseball geek, and I play fantasy baseball, so im trying to create this for fun.)

Now, I've created a button to begin, then the user follows a couple message prompts. Then Once the user selects a player, the players projected stats should appear.

This is the problem, I cannot get this to work at all. I don't know how to get VBA to to search a sheet for a player that someone selected, and output its stats on a message box.

Can anyone help me?? I'd greatly appreciated it. Thanks everyone in advance.