background preloader

Excel VBA. FREE Excel VBA Code & Excel Macro Help

Excel VBA. FREE Excel VBA Code & Excel Macro Help
TRY OUT: Smart-VBA | Code-VBA | Analyzer-XL | Downloader-XL | Trader-X Excel VBA & Macro Code Tips, Tricks FREE Excel Downloads All Excel downloads below here are free. Excel Forum FAQ List of the most popular asked questions in the Excel help forum . Excel Formulas through to Excel VBA macro code. Excel VBA Frequently Asked Questions and Answers An ever growing list of popular questions and answers on both Excel, Excel macros and Excel VBA Working With Worksheets In Excel VBA Macro Code The Macros here show us multiple ways to have our VBA Macro Code apply to specific Worksheets. Excel Charts Here are many examples that can be used to create Excel charts with a difference. InputBox Function Collect data or ranges from you users Excel Message Box (MsgBox) Function Change Excel Text Case to Upper, Lower or Proper Excel Date and Times This page is a must if you are wanting to work with dates and times in an Excel spreadsheet. Copy Multiple Column & Row Records Into Single Row Records Special!

Related:  ExcelMS Office ExcelExcel

Excel Pages Excel Pages This page describes the various pages on the web site. This is the Page Index to the Excel Web Source site. Find a set of amounts that match a target value There are instances when one wants to figure out which elements of a set of numbers (amounts) total to a target value. One instance where this may be necessary is for a company that receives a check for outstanding accounts receivable (A/R) bills but doesn't have matching documentation indicating what bills are being paid. Excel template using Solver VBA code to find multiple matching combinations References

Cookies and Excel - Excel Liberation Option Explicit Private pHtmlHandle As Long Private pHtmlName As String Private pCookieName As String Private pDays As Long ' everything to do with creating cookies in excel Msdn forums Ask a question Quick access No announcements Forums [ view all ] Selected forums Clear Match two criteria and return multiple rows in excel Question: I have a table of 3 coloms (Security name, date, price) and I have to find the price a a security at a certain date in a table that contain many securities and prices for this securities for different dates. If I work with vlookup or Index-match I got only the first price for a certain securities. So I am not able to find the price of a securities that match both the name of the securities and the date. Could you advice if there is any way to overcome?

Using Microsoft Excel Worksheet Functions in Visual Basic [Excel 2003 VBA Language Reference] The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location. Note Some worksheet functions aren't useful in Visual Basic. For example, the Concatenate function isn't needed because in Visual Basic you can use the & operator to join multiple text values. Excel: Find closest value Table of Contents Find closest value Find closest values Find closest values and return adjacent values Custom Number Formats (Multiply & Divide by any Power of 10) Posted on January 31st, 2012 in Excel Howtos , Huis , Posts by Hui - 35 comments In the past here at and at many many other sites, people have asked the question “How can I display a number Multiplied or Divided by 10, 100, 1000, 1000000 etc, but still have the cell maintain the original number for use in subsequent calculations“. Typically the answer has been limited to “It can’t be done” or “It can only be done in multiples of 1000”. Well thanks to a tip I picked up from Kyle who responded to a post here at they are all wrong.

Microsoft Access help, tutorials, examples Where to ask for help For a list of places where you can post questions, see Forums on our Links page. Brief tutorials and help for novices and database developers. Microsoft Excel VBA - Lesson 5: Variables and Data Types Sub ProcedureName() End Sub The name of a procedure should follow the same rules we learned to name the variables. In addition: Nested Functions - Nested Functions in Excel A nested function in Excel refers to one or more function being placed inside another. This is done to extend the capabilities of a function. How it works is that the nested functions are used as arguments of the first function.

Excel 2013 Shortcuts - KeyRocket Shortcut Database Never look up a shortcut again. Anyone who uses Excel knows how important it is to work as quickly as possible. However, constantly looking up shortcuts severely hurts your speed and efficiency. With KeyRocket, you’ll never have to look up another shortcut again. KeyRocket suggests relevant keyboard shortcuts with subtle notifications inside of Excel. Dead code detection and removal Increase quality, decrease files and save money by removing unused, dead code. Dead code – what's that? Dead code means unnecessary, inoperative code that can be – and should be – removed. The opposite of dead code is live, operational code. You can significantly improve a program's quality by removing dead code.