How can I turn auto correct on or off for one column only?
 

I am a high school guidance counselor and I am designing a worksheet that
will calculate GPA's for high school students. I need to type the student's
grade for a course in a column and have it change to the equivalent grade on
the 4.0 scale, for example, an 85 would be a 3.5. I know how to do this with
auto correct. The problem is that I also want to be able to type the
numerical grade on the same worksheet so that auto correct does not change
the grade. I need to have the numerical grade on the worksheet also. Is
there a way to shut auto correct off just in one column. Also, is there a
way to type a number in one cell and have that same number appear in another
cell at the same time.

right click sheet tabview codecopy/paste thisSAVE.
column3 will be the only one changed to 3.5 when you type in 85, etc

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column < 3 Then Exit Sub
Application.EnableEvents = False
Target = (Target - 50) / 10
Application.EnableEvents = True
End Sub


--
Don Guillett
SalesAid Software

"jacskier" wrote in message
...
I am a high school guidance counselor and I am designing a worksheet that
will calculate GPA's for high school students. I need to type the
student's
grade for a course in a column and have it change to the equivalent grade
on
the 4.0 scale, for example, an 85 would be a 3.5. I know how to do this
with
auto correct. The problem is that I also want to be able to type the
numerical grade on the same worksheet so that auto correct does not change
the grade. I need to have the numerical grade on the worksheet also. Is
there a way to shut auto correct off just in one column. Also, is there a
way to type a number in one cell and have that same number appear in
another
cell at the same time.

I think a lookup table or a calculation would work better than autocorrect.

also it would be possible to have one column for number grade
a second column to convert to the GPA
in the Gpa column you could have something like
=vlookup(Num,lookuptable,2)

to have an entry show in a second cell
in the second cell enter
=if(firstcell="","",first cell)
this makes the second cell be blank until something is entered in the first
cell.





"jacskier" wrote:

I am a high school guidance counselor and I am designing a worksheet that
will calculate GPA's for high school students. I need to type the student's
grade for a course in a column and have it change to the equivalent grade on
the 4.0 scale, for example, an 85 would be a 3.5. I know how to do this with
auto correct. The problem is that I also want to be able to type the
numerical grade on the same worksheet so that auto correct does not change
the grade. I need to have the numerical grade on the worksheet also. Is
there a way to shut auto correct off just in one column. Also, is there a
way to type a number in one cell and have that same number appear in another
cell at the same time.

Hi jacskier,

an 85 would be a
3.5. I know how to do this with auto correct.

are you kidding, mate?

pls. use the vlookup-function (or hlookup if you like) to pick the
correct value using your input and a table.

also want to be able to type the numerical grade on the same
worksheet so that auto correct does not change the grade.

This is why you should not use auto correct. ("Congratulations to you
85 - ehhm 3.5 - birthday, dad!")

Also, is there a way to
type a number in one cell and have that same number appear in another
cell at the same time.

if you want to see in B5 what is in A1 then use this formula in B5:
=A1

arno