Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Name: DerbyDad03 Date: March 19, 2009 at 08:22:52 Pacific
Reply:
Excel cannot have a formula in a cell and allow for user input directly into the same cell. If there is a formula in a cell, then it would get over-written when user enters 60.
There might be a way to use a Sheet_Change macro to do what you want, but you would need to be more specific.
For example, this would do what you asked. Right click the sheet tab, choose View code and paste this in the VBA window.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$1" Then
If Target = 60 Then Range("A2") = 40
End If
If Target.Address = "$A$2" Then
If Target = 60 Then Range("A1") = 40
End If
End Sub
0
Response Number 2
Name: ghost ghost Date: March 20, 2009 at 20:03:09 Pacific
Reply:
how about if I want to apply until cell F ? how to make the it keep on looping ?
0
Response Number 3
Name: DerbyDad03 Date: March 23, 2009 at 18:19:00 Pacific
Reply:
re: how about if I want to apply until cell F ?
F is not a cell.
re:
how to make the it keep on looping ?
Looping through what?
0
Response Number 4
Name: ghost ghost Date: March 28, 2009 at 19:19:21 Pacific
Reply:
mean that the formula will apply from cell A till cell Z
0
Response Number 5
Name: DerbyDad03 Date: March 28, 2009 at 19:33:25 Pacific
Reply:
A is not a cell, it's a column.
Z is not a cell, it too is a column.
I still don't know what you want to do. Please give us more detail.
0
Response Number 6
Name: ghost ghost Date: April 2, 2009 at 05:58:45 Pacific
Reply:
I mean all the formula must be apply to from cell A1 until cell Z1
0
Response Number 7
Name: DerbyDad03 Date: April 2, 2009 at 06:07:04 Pacific
Reply:
Re-read your original post.
- You wanted constants in A1 and A2 - You wanted those constants to change based on what was in each cell - You wanted a formula in A3.
Now you say I mean all the formula must be apply to from cell A1 until cell Z1.
You never asked for a formula in A1 or A2 so I still have no idea what formula you want to apply to what cell.
Give us details like you did in your first post. Your one line responses are not helping.
Summary: Hi All I need some help with a certain Excel formula. Hopefully my explanation is clear enough. Basically I have 3 columns - Days, Hours and Minutes. Currently I put in data for each column and it is ...
Summary: Hey, I am working on a quick spreadsheet for reporting for work, and everything works fine, except for 1 sheet, which i'm not sure how to do it! I'm not very advanced at excel, but i have been using V...
Summary: I am hoping someone can help me create an excel formula. Column C is the result of column A time Column B. If the resulting value in Column C is less than 8, then the value needs to be 8. If it is ...
0 
i want to add +91 in cont...
