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

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

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

In your favorite search engine type handicap excel

Many hits. Some free, some shareware.


Gord Dibben MS Excel MVP

On Fri, 12 Feb 2010 19:26:01 -0800, Big UT Fan
wrote:

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

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

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" wrote in message
...
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

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

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

"Gord Dibben" wrote:

In your favorite search engine type handicap excel

Many hits. Some free, some shareware.


Gord Dibben MS Excel MVP

On Fri, 12 Feb 2010 19:26:01 -0800, Big UT Fan
wrote:

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

.