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.
ms excel xp
Name: nsrd_in Date: July 14, 2003 at 03:07:25 Pacific OS: Windows XP Pro/Redhat Lin CPU/Ram: (933 Mhz-Intel 810E-384 M
Comment:
I have made a ms excel sheet,I need to create a way by which when i press enter on a particular cell or just click a button somehwere on the sheet automatically the value of a particular cell will get incrimented For Example-: A 1 28 2 "Update"
The cell A2 must contain a special function or button such that whenever i click on it or carry on some operation the value in cell 1 must be incrementd by some number.
Name: A Certain TH Date: July 23, 2003 at 13:36:12 Pacific
Reply:
Button Method:
Copy this macro into a module:
Sub IncrementCell() On Error GoTo Bail Range("A1") = Range("A1") + 1 Bail: End Sub
Then get a button from the Forms toolbar (View... Toolbars... Forms...) and link it to the macro. Should work. I'm not on XP, but can't believe they've changed any of that.
To do it by "sheet entry", you have multiple choices for when you want it to work. These can be: when you change the selected cell in a sheet; when you change a value on a sheet; after a given amount of time; etc etc. Write back if you want to go ahead that way.
Summary: I know how to use an IF statement to change the value of a cell in MS Excel (Office XP). But can the color of the text be changed also? Or the background fill? ...
Summary: When I go into Excel XP, everything looks fine until I click on a cell. Then select is enabled and I can't do anything else. Moving the mouse around just selects the cells where the pointer moves. Al...
Summary: In an MS Excel document, I have a PDF link that I have no problem to open anywhere else. But on my computer, when I open that link, it opens Adobe and closes it right away (the document never opens......
0 
