Search results for query: *

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

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

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

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

I am new to VBA. I use a software program that creates documents from a database. However, some times the information for the document does not exist (i.e. "accountnumber"). In those instances, the form is created just fine, but there is a line of text in the RE: for the letter that says...

I apologize for my inexperience with VBA. I have used wordperfect for many years and am just now converting. I am basing this question from what I know a wordperfect macro can do. I have a form that has bookmarks that are propogated from a case management program I am using. However, the...