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.

Find if value in column A contains value from column B?

I have two columns- column E which extends upto 99504(values) and column I which extends to 2691(values).Both the columns …

vba excel excel-2007
VBA: Conditional - Is Nothing

There is an If condition in a VBA application as seen below: If Not My_Object Is Nothing Then My_…

vba if-statement excel excel-2007 nothing
Save attachments to a folder and rename them

I'm trying to get a VBA macro in Outlook that will save an email's attachment to a specific folder and …

vba outlook attachment
Microsoft Excel ActiveX Controls Disabled?

I have some Excel worksheets that use ActiveX checkboxes to control certain activity. They worked recently but today started to …

excel vba activex
Display milliseconds in Excel

I am trying to display milliseconds in an Excel macro. I have a column of integers which are timestamps in …

excel vba time
What's the quickest way to multiply multiple cells by another number?

If I have a block of cells such as A1:D5, what's the quickest way of multiplying each cell by …

vba excel excel-formula
How to add default signature in Outlook

I am writing a VBA script in Access that creates and auto-populates a few dozen emails. It's been smooth coding …

vba ms-access outlook
How to show current user name in a cell?

In most of the online resource I can find usually show me how to retrieve this information in VBA. Is …

excel vba excel-2003 worksheet-function
filter out multiple criteria using excel vba

I have 8 variables in column A, 1,2,3,4,5 and A, B, C. My aim is to filter out A, B, C and …

excel vba excel-2010 excel-2007
What is the difference between .text, .value, and .value2?

What is the difference between .text, .value, and .value2? Such as when should target.text, target.value, and target.value2 …

excel vba