Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. tmcrae

    Excel 2003: Can a cell's value be automatically edited/updated?

    No worries! I wasn't insulted at all...just thought that I had made a mistake somewhere during the registration process! Cheers!
  2. tmcrae

    Excel 2003: Can a cell's value be automatically edited/updated?

    Gal?!?! Oops...I must have checked the wrong box somewhere on the "Personal Information" form! I took a shower this morning, and everything was where it should be so as near as I can tell, I'm still a guy. And yes, the snow is all gone here! Thanks again, Skip.
  3. tmcrae

    Excel 2003: Can a cell's value be automatically edited/updated?

    I actually got everything working yesterday afternoon. The VBA Forum you pointed me to lead me to the dicovery of the Worksheet_Change function. From there, it was just a few Google searches to find some examples, then copying and changing one to meet my needs. Thanks, Skip.
  4. tmcrae

    Excel 2003: Can a cell's value be automatically edited/updated?

    Thanks, Skip. I will.
  5. tmcrae

    Excel 2003: Can a cell's value be automatically edited/updated?

    Thanks everyone for the feedback. It sounds as though a macro may be my best (or only) solution. Can a macro be automatically triggered to run once a value has been entered into a field?
  6. tmcrae

    Excel 2003: Can a cell's value be automatically edited/updated?

    In my original post, I had said that A1 could be any number from 1 to 10. But, if it were a 1, 2 or 3, then it would have to be edited against a value in B1. And, based on B1, the value in A1 would automatically be changed to a 1, 2 or 3. If, on the other hand, A1 were keyed with anything...
  7. tmcrae

    Excel 2003: Can a cell's value be automatically edited/updated?

    Hi Skip, Well, actually I have employed Data/Validation before and it works quite well. But, in this instance, I want to be able to automatically change (not just validate) the value in a cell based on some logic automatically. Right now, if I key an invalid number in A1, I get an error box...
  8. tmcrae

    Excel 2003: Can a cell's value be automatically edited/updated?

    Oops...the title should read Excel 2007. Sorry about that.
  9. tmcrae

    Excel 2003: Can a cell's value be automatically edited/updated?

    I have a spreadsheet where I would like to incorporate some automatic editing logic. For example, let's say in cell A1 I can key a number from 1 to 10. If, however, I key a 1, 2 or 3 in A1, I want to edit that value against whatever is in B1 (which can be "A", "B" or "C"). If B1 = "A", then...
  10. tmcrae

    Excel - Protect formulas in hidden columns

    Thanks, your solution works perfectly. I was really looking for a way to mark or protect the actual columns with the formulas in them from being deleted, but this will work very well in the meantime. As a follow up, is there a way to set "Visible Columns Only" as a default on a spreadsheet, or...
  11. tmcrae

    Excel - Protect formulas in hidden columns

    I have a spreadsheet with hidden columns that contain formulas. In the unhidden columns are data that I want to clear. But when I select the entire block and press "DELETE", it also clears the formulas in the hidden columns. What is the best way to prevent this from happening (other than...
  12. tmcrae

    Is it possible to set a rule to automatically turn on/off?

    We are running Microsoft Outlook 2003 in our office. Currently, if I want to set a rule for when I will be out of the office, I must manually do so (providing, of course, that I remember to set it before I leave the office). I was wondering if it would be possible to configure it so that this...
  13. tmcrae

    EXCEL - Why is there a limit on the number of cells I can SUM?

    Nevermind. I found the problem. The sum was being performed on a column of cells that had values set to either 0 or 1 based on the value of the cell in the corresponding row of another column. Somehow, instead of a value in this other column, however, one of the cells contained a circular...
  14. tmcrae

    EXCEL - Why is there a limit on the number of cells I can SUM?

    I am trying to sum up a column of numbers (each of which is either 0 or 1) that is 7,402 cells in length. When I use the SUM function, I get a result of zero. In fact, I get a result of zero as long as the number of cells I am summing is bigger than 2,799. Once the number of cells in the...
  15. tmcrae

    Can anyone recommend a good reference book?

    Thanks Eldon. I'll check it out.
  16. tmcrae

    Can anyone recommend a good reference book?

    I am new to the Lotus Notes/Domino Designer development platform. I've taken an introductory course and have started doing some very basic work with the product (release 6), but I find the help screens (and in particular the "examples" they give) to be largely unhelpful. Can anyone...
  17. tmcrae

    Can someone recommend some Palm Software Devlopment tools?

    Thanks, I'll check it out! I forgot to mention that for this particular application, I'll need the ability to draw and store a diagram. Currently, the application in question has been programmed in PowerBuilder and the diagram functionality has been handled using MS Paint. Any ideas?
  18. tmcrae

    Can someone recommend some Palm Software Devlopment tools?

    I need to be able to create software which will run on the Palm OS platform (probably version 4.1). The application, whose basic function is to accept user inputted data and to perform calculations on it, will be used out in the field. Once data has been collected, it needs to be...
  19. tmcrae

    Is Oslo being turfed?

    I've been reading lots of articles (all rumours, mind you) stating that one of the new models Palm was planning on introducing this fall, codenamed "Oslo", will now NOT be released. In fact, many articles suggest that it was never Palm's intent to release Oslo, stating that it was...
  20. tmcrae

    duplicates on palm

    I've had problems with duplicates appearing on my Palm when I sync with Groupwise as well. It has only been within my Date Book which duplicates have occured, and they are always repeating events (birthdays and anniversaries mostly). I think (although I cannot say for certain) that it occurs...

Part and Inventory Search

Back
Top