HELP ME QUICK OR I'LL DIE

willlobb · Apr 3rd, 2002, 05:03 AM

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 ]

Tom Schreiner · Apr 3rd, 2002, 05:20 AM

Hi
I do not understand???
Sorry...
Please explain more throughly...
Tom

Audiojoe · Apr 3rd, 2002, 05:21 AM

I know it's long winded but as regards the auto-complete on the names part, if you make this box a combobox with all the names in, then change the style of it to 2-DropDownList then when you start typing the name it will auto-complete the name for you

Whew, that was a long sentence. I nearly ran out of breath...

willlobb · Apr 3rd, 2002, 05:30 AM

OK....

1) I have an excel file that records names and grades of a number of students in a class.
Right... I want to run a search via a userform. I know how to do that. But once I get a result, i want to change the grade of the result. (the search result will appear underneath cell A6). Problem is, when i run a search, Excel shows one result of the search, but it is still its own cell reference. (ie. the results appears under cell A6 but it will still be called A37 or whatever) Because of this I cannot use an absolute cell reference, or the offset command.
Basically I want to change the grade (the grade will be 2 cells right of the name) of the search result. I want to do this all on a userform with a combobox which displays the grades that can be achieved. So...
i want to change the grades of each individual entry on a userform (be it one by one or all at once) using a combobox. But I dont want to do a really really long macro.
The bit at the start of this question.. (before i wrote "So...") is what I think would be the easiest solution, But feel free to give me a new solution.

2) How do I make it so that when i begin to type a word in a userform textbox, 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.

willlobb · Apr 3rd, 2002, 05:35 AM

Audio Joe, you are a God amongst lesser men. Thanks man.

willlobb · Apr 3rd, 2002, 05:39 AM

Oh, hold on...
What if a new pupil is added to the database?
Is there a way to automatically put them into the combobox... or make the combobox relative to a column with all the entries i want in the combobox in it?

Audiojoe · Apr 3rd, 2002, 06:27 AM

To add a name, it's only one line of code you have to put in:

combobox1.additem = "Name"

It doesnt take a sec to add it

nisht · Apr 3rd, 2002, 06:35 AM

Friend,
I am not giving you the answere to your specific need. But I suggest you see my
file 'Result Sheet'.
You can download this file from my website
http://www.pexcel.com/download.htm

it is specifically programmed for making marksheets and giving grades.

You can study the formula i have used and can programme the worksheet according to your need.

nishith desai
http://www.pexcel.com
nisht@pexcel.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 3rd, 2002, 05:03 AM	#1
willlobb Board Regular Join Date: Mar 2002 Posts: 103	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 ]

Apr 3rd, 2002, 05:20 AM	#2
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Hi I do not understand??? Sorry... Please explain more throughly... Tom

Apr 3rd, 2002, 05:21 AM	#3
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	I know it's long winded but as regards the auto-complete on the names part, if you make this box a combobox with all the names in, then change the style of it to 2-DropDownList then when you start typing the name it will auto-complete the name for you Whew, that was a long sentence. I nearly ran out of breath...

Apr 3rd, 2002, 05:30 AM	#4
willlobb Board Regular Join Date: Mar 2002 Posts: 103	OK.... 1) I have an excel file that records names and grades of a number of students in a class. Right... I want to run a search via a userform. I know how to do that. But once I get a result, i want to change the grade of the result. (the search result will appear underneath cell A6). Problem is, when i run a search, Excel shows one result of the search, but it is still its own cell reference. (ie. the results appears under cell A6 but it will still be called A37 or whatever) Because of this I cannot use an absolute cell reference, or the offset command. Basically I want to change the grade (the grade will be 2 cells right of the name) of the search result. I want to do this all on a userform with a combobox which displays the grades that can be achieved. So... i want to change the grades of each individual entry on a userform (be it one by one or all at once) using a combobox. But I dont want to do a really really long macro. The bit at the start of this question.. (before i wrote "So...") is what I think would be the easiest solution, But feel free to give me a new solution. 2) How do I make it so that when i begin to type a word in a userform textbox, 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.

Apr 3rd, 2002, 05:35 AM	#5
willlobb Board Regular Join Date: Mar 2002 Posts: 103	Audio Joe, you are a God amongst lesser men. Thanks man.

Apr 3rd, 2002, 05:39 AM	#6
willlobb Board Regular Join Date: Mar 2002 Posts: 103	Oh, hold on... What if a new pupil is added to the database? Is there a way to automatically put them into the combobox... or make the combobox relative to a column with all the entries i want in the combobox in it?

Apr 3rd, 2002, 06:27 AM	#7
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	To add a name, it's only one line of code you have to put in: combobox1.additem = "Name" It doesnt take a sec to add it

Apr 3rd, 2002, 06:35 AM	#8
nisht Board Regular Join Date: Feb 2002 Location: Ahmedabad Gujarat Posts: 303	Friend, I am not giving you the answere to your specific need. But I suggest you see my file 'Result Sheet'. You can download this file from my website http://www.pexcel.com/download.htm it is specifically programmed for making marksheets and giving grades. You can study the formula i have used and can programme the worksheet according to your need. nishith desai http://www.pexcel.com nisht@pexcel.com