Why are my formulas being replaced with values in excel?
 

I am building a form for users to use to submit data. Part of the data
needed is Lat/Longs. Some of the users use decimal degrees (preferred) and
others use degrees, minutes, seconds. Using Userforms in Visual Basics, I
have created a form on which they can enter either format. In the decimal
degrees cell, I have the formula =((C1/60)+B1)/60+A1. In this formula, A1 =
degrees, B1 = Minutes, & C1 = Seconds. However, when a value is entered in
A1, B1 or C1, excel overwrites my formula and replaces it with the value.
I've never seen it where the formula is replaced by a value. Any ideas?

Why are my formulas being replaced with values in excel?
 

You may have some Worksheet Change code. Right-click your worksheet and
select View Code.

Regards,
Paul

"D Cornett" <D wrote in message
...
I am building a form for users to use to submit data. Part of the data
needed is Lat/Longs. Some of the users use decimal degrees (preferred) and
others use degrees, minutes, seconds. Using Userforms in Visual Basics, I
have created a form on which they can enter either format. In the decimal
degrees cell, I have the formula =((C1/60)+B1)/60+A1. In this formula, A1
=
degrees, B1 = Minutes, & C1 = Seconds. However, when a value is entered
in
A1, B1 or C1, excel overwrites my formula and replaces it with the value.
I've never seen it where the formula is replaced by a value. Any ideas?

Why are my formulas being replaced with values in excel?
 

Paul,
Thank you for your suggestion. I don't have any code on that particular
worksheet. I do have worksheet change code on other worksheets in the same
workbook, but not on this particular sheet or that would effect these cells
(that I can find anyway.)
Thanks again for the attempt though
D Cornett

"PCLIVE" wrote:

You may have some Worksheet Change code. Right-click your worksheet and
select View Code.

Regards,
Paul

"D Cornett" <D wrote in message
...
I am building a form for users to use to submit data. Part of the data
needed is Lat/Longs. Some of the users use decimal degrees (preferred) and
others use degrees, minutes, seconds. Using Userforms in Visual Basics, I
have created a form on which they can enter either format. In the decimal
degrees cell, I have the formula =((C1/60)+B1)/60+A1. In this formula, A1
=
degrees, B1 = Minutes, & C1 = Seconds. However, when a value is entered
in
A1, B1 or C1, excel overwrites my formula and replaces it with the value.
I've never seen it where the formula is replaced by a value. Any ideas?

Why are my formulas being replaced with values in excel?
 

Just out of curiousity, are the values matching the results of your formula
that you are attempting to enter?
Though I mentioned to look at the Worksheet code, you may also want to look
under ThisWorkbook.

Good luck.


"D Cornett" wrote in message
...
Paul,
Thank you for your suggestion. I don't have any code on that particular
worksheet. I do have worksheet change code on other worksheets in the same
workbook, but not on this particular sheet or that would effect these
cells
(that I can find anyway.)
Thanks again for the attempt though
D Cornett

"PCLIVE" wrote:

You may have some Worksheet Change code. Right-click your worksheet and
select View Code.

Regards,
Paul

"D Cornett" <D wrote in message
...
I am building a form for users to use to submit data. Part of the data
needed is Lat/Longs. Some of the users use decimal degrees (preferred)
and
others use degrees, minutes, seconds. Using Userforms in Visual
Basics, I
have created a form on which they can enter either format. In the
decimal
degrees cell, I have the formula =((C1/60)+B1)/60+A1. In this formula,
A1
=
degrees, B1 = Minutes, & C1 = Seconds. However, when a value is
entered
in
A1, B1 or C1, excel overwrites my formula and replaces it with the
value.
I've never seen it where the formula is replaced by a value. Any ideas?

Why are my formulas being replaced with values in excel?
 

Depends on how I enter the data. If I enter the data using the form, it does
not match. It calculates based on the first entry I make (regarless of which
I start with) and zero (or whatever is already in the cell) for the other
two. If I enter the data directly into the cell, it seems to calculate
correctly and SOMETIMES replaces the formula with the value.
I don't have any code under the ThisWorkbook level.

"PCLIVE" wrote:

Just out of curiousity, are the values matching the results of your formula
that you are attempting to enter?
Though I mentioned to look at the Worksheet code, you may also want to look
under ThisWorkbook.

Good luck.


"D Cornett" wrote in message
...
Paul,
Thank you for your suggestion. I don't have any code on that particular
worksheet. I do have worksheet change code on other worksheets in the same
workbook, but not on this particular sheet or that would effect these
cells
(that I can find anyway.)
Thanks again for the attempt though
D Cornett

"PCLIVE" wrote:

You may have some Worksheet Change code. Right-click your worksheet and
select View Code.

Regards,
Paul

"D Cornett" <D wrote in message
...
I am building a form for users to use to submit data. Part of the data
needed is Lat/Longs. Some of the users use decimal degrees (preferred)
and
others use degrees, minutes, seconds. Using Userforms in Visual
Basics, I
have created a form on which they can enter either format. In the
decimal
degrees cell, I have the formula =((C1/60)+B1)/60+A1. In this formula,
A1
=
degrees, B1 = Minutes, & C1 = Seconds. However, when a value is
entered
in
A1, B1 or C1, excel overwrites my formula and replaces it with the
value.
I've never seen it where the formula is replaced by a value. Any ideas?