Thread
:
is there a way to enter data interactively and dynamically?
View Single Post
#
10
Posted to microsoft.public.excel.misc,microsoft.public.excel
[email protected]
external usenet poster
Posts: 6
is there a way to enter data interactively and dynamically?
cf, obviously I didn't realize the savefile address would show up as a
link, so just click on the link! James
wrote:
cf, Glad to be of help. I set up a savefile account to pass files, so
that would be the best way to get it to you. The address is
http://www.savefile.com/files/148073
Just copy that address and paste it in your browser address window.
When you get to the site, click the Download button.
After downloading, open the file and click the little Go button or
press Ctrl-z. Type in a few letters of one of the names to locate a
student's row. Tab to go to the grade box. Type in grade. Tab to go
to the column box. You can enter the column letter or the column
number. Press OK to enter the grade. If you think you made a mistake,
press the < button to go back (it only remembers the last one).
Make a backup copy of your file before trying to hook it up to this.
Let me know if it works for you and if you need help in hooking it up
to your file. James
cfman wrote:
wrote in message
oups.com...
cf, My little file just assumes the Student names are in column A. It
could be taught to use a different column to find the names, if
necessary. You type in the first few letters of the name and it finds
it. Then you tab to the grade box and put in the grade. You set the
column in the form to put the scores in, and it just keeps using that
column until you change it in the form. So it would be a matter of
typing in a few letters, tab, put in grade, press OK and repeat until
all grades are in. Easy. Yes, it's an Excel file, using only Excel
VBA. James
Wonderful! It is the smart people such as James in the world that makes our
lives easier and not a myserable one...
Thank you so much James...
Could you please kindly send me the program to my email address:
?
I appreciate your help!
Reply With Quote
[email protected]
View Public Profile
Find all posts by
[email protected]