Recent content by wordperfectconvert

Thanks to all who contributed. I gave up on attempting to learn the VBA code. It is way over my head. For those looking for the answer, here is my solution. I set up a separate worksheet named MaxWage that had 4 columns and 20 rows. I then used the following formula in the cell I was using...

Thanks to all who contributed. I gave up on attempting to learn the VBA code. It is way over my head. For those looking for the answer, here is my solution. I set up a separate worksheet named Mortality that had 3 columns and 91 rows. I then used the following formula in the cell I was...

Thanks to all who contributed. I gave up on attempting to learn the VBA code. It is way over my head. For those looking for the answer, here is my solution. I set up a separate worksheet named Mortality that had 3 columns and 91 rows. I then used the following formula in the cell I was...

The mortality information is not contained in THIS table. I am pulling it from a 2001 standard mortality table used for this circumstance. I don't want to clutter up my calculator with the entire mortality table. I would prefer to enter a formula for each age and sex, even though it would...

I was referred from VBA forum to this forum. I have a table where B1 ( named B1 "Sex") asks for sex ("male" or "female") and B2 asks for Date of Birth. B3 (named "Age") calculates the persons age. B4 has been named "LifeExpectancy". I have to use a specific mortality table for my purposes. I...

There is no underlying formula as it comes from an actuarial table. I asked the publishers of the table. (I agree there should be a formula, but they say it is not a constant)

SkipVough, I beg to differ. Two reasons, the variables end up with 160 options and that is too many for excel to handle. Second, I intend to publish the spreadsheet or calculator on my web page in html format and have been advised that for this cell I should use VBA code for the formula. I...

I have a spreadsheet where the user enters the date of an event. Cell B2 is the date of the event. For example, if B2 is 1/1/07, I need to have cell C2 enter $431.00. If B2 is 1/1/08, I need to have cell C2 enter $461.00. I literally am struggling with everything. I started with Private Sub...

I have an excel spreadsheet where the person enters sex (male or female) in B2, the date of birth in B3, and B4 calculates the age at last birthday. I want b5 to say somethine like "If B2 is Male and age is 47, then B5 (life expectancy) is 28.45". I could do this with an If formula, but only...

I have a third party application that we use to create documents such as letters. The application fills the template with the use of bookmarks. I have some standard bookmarks set up in a table, but occasionally we will not have the information in our third party database, so the bookmark will...

Roy-Vidar, Thank you. The AutoNew worked perfectly. Problem solved. Tony, Thanks for response. That is part of the problem. I don't know exactly how the case management program is opening the template, but Roy-Vidar's suggestion of AutoNew worked fine. Bill

I use a case management program that assembles data to be placed in documents. I have created a number of templates to use with the program. When the case management program opens the documents, the AutoOpen macro commands don't work. I am at a total loss on how to make the macros run when...

Thanks Roy-Vidar, that worked perfectly. Bill

I have created a series of user boxes that come up in the process of creating a letter template. Both user boxes have "OK", "Skip this step" and "Cancel" buttons. I have found that I often want to either skip or cancel. How do I program the command buttons so that I can hit Alt + "s" to use...

Tony, Thanks for the response. I tried it with a true bookmark and got an error for the portion of the code that read: Selection.Bookmarks("\Line").Delete I also tried it with a form field, but it read the field as not being empty and took no action. The only way I could get it to work was...