blonde poker forum

Community Forums => The Lounge => Topic started by: cambridgealex on February 04, 2011, 03:45:26 PM



Title: Anyone good with visual basic/VBA on excel?
Post by: cambridgealex on February 04, 2011, 03:45:26 PM
I messed around with this at school but completely forgotten all of it. Basically I'm trying to create a very simple program to input poker sessions to. A few buttons, drop down menus etc. I wanna be able to see a graph of results, a list of results and filter between tourneys and cash. That's about it.

I know there are loads of programs that can do this available, but firstly I quite want to make one myself and secondly all of those have tons of boxes etc and make you fill in information that I don't really care about. I don't want loads of clutter on the screen, just a simple process of putting in session date, length, profit and cash/tourney then a few stats like cumulative profit and monthly profit and then have the option to view the database as a graph or lists.

My current excel spreadsheet is alright but I'd like to use the VB stuff within excel to improve it.

[X] have too much time on my hands

Thank youuuu!


Title: Re: Anyone good with visual basic/VBA on excel?
Post by: kinboshi on February 04, 2011, 03:51:05 PM
There are a few sites that have tools that do all of this for you (of course you can make a spreadsheet do a lot more potentially, but it'd be some graft).

There's the one on the Hendon Mob site - My Poker Diary.  That should do most of what you want from a spreadsheet - plus it has the advantage of being online - so you could update it from your phone, or laptop or whatever.  Poker Dominator is another - others will probably know of lots more.


Title: Re: Anyone good with visual basic/VBA on excel?
Post by: AndrewT on February 04, 2011, 10:28:39 PM
Pretty good spreadsheet here - http://www.pokerspreadsheets.com/spreadsheets/other/results_monitoring.xls