thanks mike, are you able to provide some advice on the code I will need to
perform the following task:
I have named ranges in my worksheet, student_name student_number
HLTAP401A_mid_semester_exam HLTAP401A_mid_resit and others
What would the code be in the combo boxes that would allow the user to
select a course, then either Student ID or student name, then enter a grade
of a U or S in the subject they selected.
I just can't find annthing that looks up one range of data and then enters
the result in the corresponding selected range... thinking it might be
vlookup just so stuck
"Mike Fogleman" wrote:
> Check out John's site on userforms:
> http://spreadsheetpage.com/index.php/tip/C29/P0/
> There are plenty of companion files to download.
>
> Mike F
> "Paul" <(E-Mail Removed)> wrote in message
> news:390DBF7D-DCEF-473A-86BA-(E-Mail Removed)...
> > thanks Shane for your reply, I have previously look on the internet fo
> > rinformation about userforms. I am really time poor as we all are, so have
> > been able to sit down and learn from the beginning. as for my problem have
> > you any advice to solve it?
> >
> >
> > "ShaneDevenshire" wrote:
> >
> >> Hi,
> >>
> >> this isn't free but John Walkenbach's Power Programing in Excel has over
> >> a
> >> hundred pages on this topic area.
> >>
> >> Google "Creating Excel User Forms" and you will see a couple of good
> >> sites
> >> right at the top of the list.
> >>
> >>
> >> If this is helpful, click the Yes button.
> >> --
> >> Thanks,
> >> Shane Devenshire
> >>
> >>
> >> "Paul" wrote:
> >>
> >> > Hello all, I was wondering is there a training site that deals with
> >> > userforms, searched madly but not able to find a free one. any
> >> > suggestions.
> >> >
> >> > I am not that computer savvy so any help with my question would be
> >> > great.
> >> >
> >> > I have a spreadsheet with student results I want to automate, I ve
> >> > created a
> >> > userform that askes the teacher to select the subject assignment they
> >> > wish to
> >> > enter
> >> > this then leads to another user form where the teacher either enters
> >> > the
> >> > student id number or name and then a result of only a U or an S, they
> >> > click
> >> > ok to enter another grade or cancel to stop.
> >> >
> >> > Big problem is I don't know how to do the code.
> >> >
> >> > this is the spreadsheet
> >> >
> >> > student no. last name first name en401ass1 en401ass2 final grade
> >> > en555ass1
> >> > ....
> >> > 025554 chuck john
> >> > 115666 duncan peter
> >> > 5665 skinner sam
> >> >
> >> > etc
> >> >
> >> > Have been stuggling with this for so long please help
> >> >
>
>
>