Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 8 of 8

Thread: HELP ME QUICK OR I'LL DIE

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    103
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ]

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Where the wild roses grow
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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...

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Posts
    103
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  5. #5
    Board Regular
    Join Date
    Mar 2002
    Posts
    103
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

  6. #6
    Board Regular
    Join Date
    Mar 2002
    Posts
    103
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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?

  7. #7
    Board Regular
    Join Date
    Feb 2002
    Location
    Where the wild roses grow
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  8. #8
    Board Regular
    Join Date
    Feb 2002
    Location
    Ahmedabad Gujarat
    Posts
    303
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

    ni****h desai
    http://www.pexcel.com
    nisht@pexcel.com

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •