Microsoft Excel VBA Like Operator and Wildcard Characters by Kenny L Keys

Microsoft Excel VBA Like Operator and Wildcard Characters

byKenny L Keys

Kobo ebook | August 30, 2013

Pricing and Purchase Info

$2.04

Prices and offers may vary in store

Available for download

Not available in stores

about

This five-minute eBook will quickly show anyone how to use Microsoft’s VBA operators (e.g., <_2c_>, Like, And) and its wildcard characters (e.g., #, ? and *) to filter for data in spreadsheet cells.  If a user has ever worked with filtering data in Microsoft Access databases, he or she will be very familiar with these operators and wildcard characters and how they’re used to extract data, but the user must use these operators and wildcard characters in VBA codes differently than he or she would use them in the Microsoft Access Query View window.  Although Microsoft has done a very good job creating unique applications to meet the needs of its users, it knows that some users want more control over their applications; these individuals choose to use VBA to manage them, e.g., Word, Excel, PowerPoint and Access; however, this eBook will only cover Microsoft Excel VBA functions.

Using the Like operator along with wildcard characters will allow a user to quickly filter for data that she or he needs and wants within a matter of seconds, without needing to type Microsoft formulas and functions in each corresponding cell for the data that he or she is trying to extract or filter for, e.g., “Sharon Mays lives at 2589 Mathew Lane” Like “Sharon Mays*Mathew L???.”

Using the And operator allows a user to instruct Microsoft Excel to ensure that two or more criteria are met before a condition or statement can lead to true, e.g., 3 > 0 And 3

Users will learn how to use the greater than (>) and less than (<_29_ operators="" along="" with="" a="" couple="" wildcard="" characters="" _28_e.g.2c_="" _2a_2c_="" in="" this="" _book2c_="" and="" _ie28099_ll="" explain="" one="" entire="" vba="" code="" line="" by="" _line2c_="" so="" users="" will="" gain="" clearer="" understanding="" of="" how="" each="" has="" specific="" task="" or="" _function.c2a0_="" when="" complete="" small="" about="" 5="" _minutes2c_="" he="" she="" should="" feel="" comfortable="" writing="" his="" her="" own="" microsoft="" excel="" to="" filter="" for="" spreadsheet="">

I’ve included links to public freebies at the end of this book to further assist users in learning to effectively use VBA codes in their Microsoft Excel spreadsheets.

This small book doesn’t contain an index, a reference section or a study guide.

Title:Microsoft Excel VBA Like Operator and Wildcard CharactersFormat:Kobo ebookPublished:August 30, 2013Publisher:Kenny L KeysLanguage:English

The following ISBNs are associated with this title:

ISBN:9990005569774

Look for similar items by category:

Reviews