Why are my formulas being replaced with values in excel?

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?
 
P

PCLIVE

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

Regards,
Paul
 
D

D Cornett

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
 
P

PCLIVE

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

D Cornett

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top