Search results for query: *

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

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.

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.

Thanks, Skip. I will.

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?

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...

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...

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

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...

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...

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...

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...

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...

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...

Thanks Eldon. I'll check it out.

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...

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?

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...

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...

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...