Excel/Access VBA String Functions

Excel/Access VBA String Functions

Here are the VBA codes for manipulating strings.

• Left Function
• Right Function
• Mid Function
• Len Function
• Replace Function

Link: Excel Shortcut Keys

Excel VBA to get the Last Used Row and Last Used Column.

Here's how to determine the last used row and last used column in excel.

• Get the last row in one column: End(xlUp)
• Get the last row in one column: UseRange.Rows.Count
• Get the last column in one row: End(xlToLeft)
• Get the last column in one row: UseRange.Columns.Count

Excel/Access VBA Speech.Speak

Microsoft Office programs can run voice commands with the speech recognition feature which can be installed as part of a MS Office installation.

Link: Excel Shortcut Keys

Excel/Access VBA that sends email via Outlook

Here's the code that send email via Outlook using MS Access VBA.  You need to add a reference to the Outlook object model in the Visual Basic editor. Then you can use the code below to send an email using outlook.   

Link: Excel Shortcut Keys