D
D Cornett
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?
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?