Excel Help

vtbub · 05-24-2011, 02: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, 03: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, 08:25 AM

Check here with this fellow:

TableTopSportsGames

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, 08:28 AM

macros in excel are awesome.

05-24-2011, 03:05 PM	#2
Suburban Rhythm Pro Starter Join Date: Jan 2002 Location: Pittsburgh	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. __________________ "Do you guys play fast tempos with odd time signatures?" "Yeah" "Cool!!"

05-25-2011, 08:25 AM	#3
OldGiants College Benchwarmer Join Date: Oct 2000 Location: Location, Location, Location	Check here with this fellow: TableTopSportsGames 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. __________________ "The case of Great Britain is the most astonishing in this matter of inequality of rights in world soccer championships. The way they explained it to me as a child, God is one but He's three: Father, Son and Holy Ghost. I could never understand it. And I still don't understand why Great Britain is one but she's four....while [others] continue to be no more than one despite the diverse nationalities that make them up." Eduardo Galeano, SOCCER IN SUN AND SHADOW

05-25-2011, 08:28 AM	#4
CrimsonFox Head Coach Join Date: Dec 2009	macros in excel are awesome.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)