View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default 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