PC Review


Reply
Thread Tools Rate Thread

combo boxes entering data

 
 
Paul
Guest
Posts: n/a
 
      18th Oct 2008
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

 
Reply With Quote
 
 
 
 
ShaneDevenshire
Guest
Posts: n/a
 
      18th Oct 2008
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
>

 
Reply With Quote
 
Paul
Guest
Posts: n/a
 
      18th Oct 2008
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
> >

 
Reply With Quote
 
Paul
Guest
Posts: n/a
 
      19th Oct 2008
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
> >> >

>
>
>

 
Reply With Quote
 
Mike Fogleman
Guest
Posts: n/a
 
      19th Oct 2008
My advice at this time, in order for you to get something working right away
is to use the built-in Data Form. UserForms are great for creating a custom
interface for the user, but also have a steep learning curve for the novice
developer.
The Data Form has a search by criteria feature and can be used immediately
on your data list and will do exactly as you wish to do.

Now you will have some time to learn the UserForm using examples from John's
companion files at your own pace.

Mike F
"Paul" <(E-Mail Removed)> wrote in message
news:82E0223C-A0E1-4EE8-93BF-(E-Mail Removed)...
> 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
>> >> >

>>
>>
>>



 
Reply With Quote
 
Paul
Guest
Posts: n/a
 
      19th Oct 2008


"Mike Fogleman" wrote:

> My advice at this time, in order for you to get something working right away
> is to use the built-in Data Form. UserForms are great for creating a custom
> interface for the user, but also have a steep learning curve for the novice
> developer.
> The Data Form has a search by criteria feature and can be used immediately
> on your data list and will do exactly as you wish to do.
>
> Now you will have some time to learn the UserForm using examples from John's
> companion files at your own pace.
>
> Mike F
> "Paul" <(E-Mail Removed)> wrote in message
> news:82E0223C-A0E1-4EE8-93BF-(E-Mail Removed)...
> > 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
> >> >> >
> >>
> >>
> >>

>
>
>

 
Reply With Quote
 
Paul
Guest
Posts: n/a
 
      19th Oct 2008

thanks for the suggestion mike but I have spent most of the past 2 days
trying to find out the code to do this.

I can populate a list box by changing the property but I can't find code
that will use the first userform range to then look up student id and then
enter data in the corresponding range.

I am so frustrated

what is the code for a combo box that looks up a range called student id or
student name, then finds the subject previously entered and then enters the
grade in the corresponding range.

I have read so many items in the forum and done many examples but nothing is
close to this. pleasae help if you can.
"Mike Fogleman" wrote:

> My advice at this time, in order for you to get something working right away
> is to use the built-in Data Form. UserForms are great for creating a custom
> interface for the user, but also have a steep learning curve for the novice
> developer.
> The Data Form has a search by criteria feature and can be used immediately
> on your data list and will do exactly as you wish to do.
>
> Now you will have some time to learn the UserForm using examples from John's
> companion files at your own pace.
>
> Mike F
> "Paul" <(E-Mail Removed)> wrote in message
> news:82E0223C-A0E1-4EE8-93BF-(E-Mail Removed)...
> > 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
> >> >> >
> >>
> >>
> >>

>
>
>

 
Reply With Quote
 
Paul
Guest
Posts: n/a
 
      19th Oct 2008
Mike I appreciate your reply, but I have spent the past 2 days searching for
code that will solve my problem. I just can't find any code that will use the
selection in one combo box... in this case a subject selected by the first
combo box, then with the second combo box ask for the student number or name
to then enter a U or an S in the subject selected in the first combo box.

lots of code show how to display text already entered and othes about
populating list boxes by changing the property but nothing comes close....

I am so so frustrated please help if you can.

"Mike Fogleman" wrote:

> My advice at this time, in order for you to get something working right away
> is to use the built-in Data Form. UserForms are great for creating a custom
> interface for the user, but also have a steep learning curve for the novice
> developer.
> The Data Form has a search by criteria feature and can be used immediately
> on your data list and will do exactly as you wish to do.
>
> Now you will have some time to learn the UserForm using examples from John's
> companion files at your own pace.
>
> Mike F
> "Paul" <(E-Mail Removed)> wrote in message
> news:82E0223C-A0E1-4EE8-93BF-(E-Mail Removed)...
> > 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
> >> >> >
> >>
> >>
> >>

>
>
>

 
Reply With Quote
 
Paul
Guest
Posts: n/a
 
      19th Oct 2008
ps I tried the built in form but it says i have too many fields

arrrrggghhh

"Paul" wrote:

> Mike I appreciate your reply, but I have spent the past 2 days searching for
> code that will solve my problem. I just can't find any code that will use the
> selection in one combo box... in this case a subject selected by the first
> combo box, then with the second combo box ask for the student number or name
> to then enter a U or an S in the subject selected in the first combo box.
>
> lots of code show how to display text already entered and othes about
> populating list boxes by changing the property but nothing comes close....
>
> I am so so frustrated please help if you can.
>
> "Mike Fogleman" wrote:
>
> > My advice at this time, in order for you to get something working right away
> > is to use the built-in Data Form. UserForms are great for creating a custom
> > interface for the user, but also have a steep learning curve for the novice
> > developer.
> > The Data Form has a search by criteria feature and can be used immediately
> > on your data list and will do exactly as you wish to do.
> >
> > Now you will have some time to learn the UserForm using examples from John's
> > companion files at your own pace.
> >
> > Mike F
> > "Paul" <(E-Mail Removed)> wrote in message
> > news:82E0223C-A0E1-4EE8-93BF-(E-Mail Removed)...
> > > 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
> > >> >> >
> > >>
> > >>
> > >>

> >
> >
> >

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combo boxes and lists boxes not showing data Annette Microsoft Access 1 24th Jan 2008 12:50 PM
data access page combo boxes and test boxes not visable or print =?Utf-8?B?Y3RhejJkYXk=?= Microsoft Access 0 26th Jul 2005 02:31 AM
Clear data in text boxes / combo boxes =?Utf-8?B?Q2hyaXM=?= Microsoft Access 4 31st May 2005 08:07 AM
How do i stop the user entering the same value in two combo boxes? =?Utf-8?B?TW9ua2V5IE1hbg==?= Microsoft Access Forms 5 8th Apr 2005 03:03 PM
Combo Boxes and Blocking entering text Marcy Microsoft Excel Worksheet Functions 0 9th Jan 2004 03:03 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:53 PM.