Tag Archive: vba excel 2007

Mar
19
2013

Uppercase/Lowercase conversion in Excel through VBA

Well, there is no easy way to ‘change case’ in excel. So i wrote few small VBA snippets to perform case conversion. To perform uppercase conversion on the selected cells Sub UpperCase() Dim Cell As Object For Each Cell In SelectionCell.Value = StrConv(Cell.Value, vbUpperCase) Next End Sub To perform lowercase conversion on the selected cells …

Continue reading »

Jan
26
2012

How to use the VBA find and replace function

I like the single line function yet powerful command with VBA to perform find and replace functionality. It’s used for String (text) find and replacement Here is the syntax to use it, <result string> = Replace (<string to process>, <find what>, <replace with>) Here is a sample, Dim sampleText As String Dim resultString As String …

Continue reading »

Jan
16
2012

Handy Excel Macros > Automate Excel Text Formatting

Excel_logo

When working with the Microsoft office documents or spreadsheets we end up doing the formatting so manually every time. Let us take a real time case. I am need to create a spreadsheet with about 100 titles and 500 entries and i need to copy them from various web pages and e-mails. I want all …

Continue reading »

Jan
15
2012

Assigning Excel 2007 Macros to Buttons / Trigger VBA Macros from Buttons

Excel macros are excellent time savers. It is a good idea to assign some keyboard shortcuts to trigger them quickly to make the most of them. Alternatively we can trigger them from buttons as well as well (if you find it difficult to remember too many keyboard short cuts). In this post I am going …

Continue reading »