PDA

View Full Version : Excel Help


vtbub
05-24-2011, 01:54 PM
Yo!

I've created a baseball game, cards and dice to start, but would like some help in making some of the cards automatically in excel. I have the data and pretty much know what should be in each cell, but doing them out long hand is brain-draining and time consuming.

How easy is VBA to learn and is taking raw data and formatting it into a game card possible?

Suburban Rhythm
05-24-2011, 02:05 PM
Question 2 first-- without knowing how exactly you want them to look, I would say it's doable.

VBA...I am by no means an expert, and most of what I do know is self taught.

If you are comfortable in Excel, one option is recording the macro as you do one iteration of the steps you want to repeat. Then step into the VBA and see what it looks like written out.

OldGiants
05-25-2011, 07:25 AM
Check here with this fellow:

TableTopSportsGames (http://tabletopsportsgames.homestead.com/tabletopsportsgames.html)

He has several Excel based sports games and is more than willing to share thoughts and techniques. He does generate APBA-style cards for his baseball game, so he should know how to do what you are looking to do.

He does use VBA to make these games, I know.

CrimsonFox
05-25-2011, 07:28 AM
macros in excel are awesome.