Edit Multiple Selections in Excel Drop Down Lists

Microsoft has come up with an amazing array of features in Excel. One such feature is the drop down list which creates the ability for the user to provide feedback that drives other parts of the workbook. Gathering feedback from your audience not only allows your them to change scenarios as they see fit but it prevents you from recreating reports for each scenario.

As with any feature there are limitations. This is where the beauty of VBA comes into play! In yesterday's blog post from Contextures.com we are shown how you can handle problems with editing drop down lists:

Contextures Blog » Edit Multiple Selections in Excel Drop Down Lists

Get Rid of Page Break Lines with a snap [macros] | Chandoo.org - Learn Microsoft Excel Online

Get Rid of Page Break Lines with a snap [macros] | Chandoo.org - Learn Microsoft Excel Online

John Walkenbach on Excel

To learn more about Excel, take a look at the selection of books now available from:

Mr Spreadsheet

Creating arrays using VBA

Now with an understanding of the power of arrays we can build upon this using VBA.  Here is a very thorough overview of arrays from a highly respected source:

http://www.cpearson.com/excel/vbaarrays.htm

Please visit our sponsors to the right for more resources available on Excel & VBA today!

Mr Excel & excelisfun Trick 67: Extract Initials From Full Name: VBA or ...