Help please - I want to program an interface to Excel 2003

[Big UT Fan]

I have an Excel 2003 spreadsheet that I keep golf scores and with some
formulas I maintain my golf handicap. I would like to have an interface,
form, etc that will allow me to do the following:
1) Enter data for a golf round (name, date, course, rating1, rating2, score)
2) Display data for a golfer
3) Perform functions on the data in the spreadsheet (modify/delete data,
compute handicaps, etc)

I'm not sure if there is something within Excel (VBA?) that will allow this
or if there is some shareware or freeware that is specifically designed for
this but any help would be greatly appreciated. Also, if this would be
easier to accomplish using Access I'll look into that.

Thanks, Mike

 

[Gord Dibben]

In your favorite search engine type handicap excel

Many hits. Some free, some shareware.


Gord Dibben MS Excel MVP

 

[Peter T]

You could certainly make a nice UI or dialog with VBA for what you describe,
however there is a learning curve.

There's a much simpler built-in approach though, in Excel 2003 select any
cell in your data and do
Data, Form...
and go from there

This of course won't do anything you asked for in 3), that's another
subject.

Regards,
Peter T

 

[Big UT Fan]

Thanks Gord...done that before. Not what I'm looking for. Want to do roll
my own so to speak.