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?

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?

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?

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?

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?