OK....
1) I have an excel file that records names and grades of a number of students in a class.
I want to find a way that I can, via a userform, input the grades of each person... I figured the best way would be to run a search on the userform then change the grade of the result.
Problems with this include 'what happens if I get more than one result from my search?'
to input the grade, rather than having to do absolute cell references for each person, I wanted a way to go 'down right right' when only one result was found' and input the grade via that.
Hope that makes sense....
2) How do I make it so that when i begin to type a word in a userform, the word will be finished by an entry in my list?
eg. I write "Ad" and the word is finished off to "Adam" but if i carry on writing and go to "Adr" it finishes to the word "Adrian". Please bear in mind I have 300 entries in my list.
Thanks a lot.
This message was edited by willlobb on 2002-04-03 04:12
This message was edited by willlobb on 2002-04-03 04:19
This message was edited by willlobb on 2002-04-03 04:43
1) I have an excel file that records names and grades of a number of students in a class.
I want to find a way that I can, via a userform, input the grades of each person... I figured the best way would be to run a search on the userform then change the grade of the result.
Problems with this include 'what happens if I get more than one result from my search?'
to input the grade, rather than having to do absolute cell references for each person, I wanted a way to go 'down right right' when only one result was found' and input the grade via that.
Hope that makes sense....
2) How do I make it so that when i begin to type a word in a userform, the word will be finished by an entry in my list?
eg. I write "Ad" and the word is finished off to "Adam" but if i carry on writing and go to "Adr" it finishes to the word "Adrian". Please bear in mind I have 300 entries in my list.
Thanks a lot.
This message was edited by willlobb on 2002-04-03 04:12
This message was edited by willlobb on 2002-04-03 04:19
This message was edited by willlobb on 2002-04-03 04:43