Top "Vba" questions

Visual Basic for Applications (VBA) is an event-driven, object-oriented programming language for writing macros, used for the entire Office suite as well as other applications.

How to copy to clipboard using Access/VBA?

Using VBA inside Access2003/2007. How to copy the contents of a string variable to the clipboard? This site recommends a …

windows ms-access clipboard vba
Looping through all rows in a table column, Excel-VBA

I'm currently working on a data set which is formatted as a table, with headers. What I need to do …

vba excel excel-2010
Removing special characters VBA Excel

I'm using VBA to read some TITLES and then copy that information to a powerpoint presentation. My Problem is, that …

vba excel excel-2010
Excel 2010: how to use autocomplete in validation list

I'm using a large validation list on which a couple of vlookup() functions depend. This list is getting larger and …

vba excel excel-2010
Excel tab sheet names vs. Visual Basic sheet names

It seems that Visual Basic can not reference sheets according to user-modified sheet names. The worksheet tabs can have their …

vba excel worksheet
VBA Print to PDF and Save with Automatic File Name

I have a code that prints a selected area in a worksheet to PDF and allows user to select folder …

excel vba pdf autosave
ShowAllData method of Worksheet class failed

I notice my VBA script doesn't work when there's an autofilter already on. Any idea why this is? wbk.Activate …

excel vba autofilter
How to insert values into the database table using VBA in MS access

I've started to use access recently. I am trying to insert a few rows into the database; however, I am …

sql ms-access vba ms-access-2010
Excel vba - convert string to number

So, I used the left function to take the first 4 characters of a string and I need to run a …

string vba numbers vlookup
Add newline to VBA or Visual Basic 6

I want to concatenate two strings with a linebreak between them. st = "Line 1" + newline + "Line2" How do I add a …

vba vb6