Excel Hints has been having trouble with the SQL databases used by WordPress recently. It appears we have worked out most of the problems. I would like to apologize to all the readers of the site for the down time and thank you for your continued support. New postings will continue soon. If you want to contact me, please use our contact form.
Thanks You,
John
ExcelHints.com
In this post, I’m am going to start off with just showing you the parts of a basic macro and how you can get to the editor. To see this feature for your self the first thing you want to do is record a macro. Try typing some text in a cell, maybe some copying and pasting, anything. Next were going to take a look at the code and see what happened.
Getting to the VBA Editor
After you record you macro and hit stop, the next step is to take a look at it and see what’s been recorded. There are 2 ways to get to the Visual Basic editor:
Lately all the updates I have been adding to excel hints have been related to the formulas that are incorporated into Microsoft Excel. While I still probably have hundreds of formulas that need added to this site, I am going to begin adding tips on how to use the Macro capabilities for Excel.Â
 Macros in Microsoft Excel are written in Visual Basic for Applications (or VBA), which is just a program to provides you with the ability to a little more functionality to your spreadsheets. Macros are an excellent choice to use for any repetitive tasks you need to accomplish, and the examples I will provide will make that obvious. As with the formulas added to the site, we will begin with some basic functions and build upon them.
 Anyone that has any suggestions on something that they would like to see on the site or suggestions on how I can make the site better, please contact me using the contact form.
Whether you are trying to buy a new house, looking at buying a new car or applying for MORE student loans, you have no doubt wondered what your monthly payment would be. Excel provides an easy to use formula in which you can enter the loan information, and it will calculate the monthly payment for you. Once you learn to use it, it’s actually very simple. So let’s go ahead and take a look at the PMT Formula: Continue Reading »
I recently received an email from a reader asking how to add a hidden drop down menu inside a cell. I was unable to respond back to the reader (email address was invalid), but I thought it was a great question and wanted to add it to Excel Hints. In just a couple steps, you’ll be able to add this feature to your spreadsheet and improve the validity of many spreadsheets you create. Continue Reading »
How many times have you tried to import a file into Excel, only to have extra blanks all over the place in the document? Well that’s where the Trim Formula can come into play. The Trim formula is used to clean up and remove all the leading and trailing blanks as well as all but one blank in-between text that you may have in a list of cells. So now instead of going into each cell one-by-one, there is one formula to do all the work for you. Let’s take a look at the formula first (it’s a short one):
=Trim(text)
This formula is very easy to use but can make you job a whole lot easier. Let’s take a look at some of the examples now.
First of all, I’d like to thank everyone that has subscribed to Excel Hints over the last month or so. I have been a little busy with changes at my full time job as well as other websites I’m working on, so the posting on here has been put on hold for the last month and a half. Starting next week, I have it on my schedule to begin adding posts to Excel Hints again.
Again, thank you for your patience and hopefully I can get some more good tips on her that will help you with your projects. If you have any questions or comments please use the contact form or leave a comment under a particular post.
Thanks, John.
Comments(0)
