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.

Is there a way to crack the password on an Excel VBA Project?

I've been asked to update some Excel 2003 macros, but the VBA projects are password protected, and it seems there's a …

excel vba passwords
How do I declare a global variable in VBA?

I wrote the following code: Function find_results_idle() Public iRaw As Integer Public iColumn As Integer iRaw = 1 iColumn = 1 And …

excel vba scope global-variables
How to use Regular Expressions (Regex) in Microsoft Excel both in-cell and loops

How can I use regular expressions in Excel and take advantage of Excel's powerful grid-like setup for data manipulation? In-cell …

regex excel vba
How Do I Convert an Integer to a String in Excel VBA?

How do I convert the integer value "45" into the string value "45" in Excel VBA?

vba string type-conversion integer
Check if a string contains another string

I want to find if a string contains a ","(comma) in it. Do we have any other option other than …

string vba
How to return a result from a VBA function

How do I return a result from a function? For example: Public Function test() As Integer return 1 End Function This …

excel vba function return return-value
Excel VBA - exit for loop

I would like to exit my for loop when a condition inside is met. How could I exit my for …

excel vba for-loop
Copy Paste Values only( xlPasteValues )

I'm trying to copy entire column in sheetA to Sheet B. sheetA column has values formed with formuls. I'm copying …

excel vba copy-paste
How to activate a specific worksheet in Excel?

I just need to activate a certain worksheet. I have a string variable that keeps the name of the worksheet.

excel vba
How to pause for specific amount of time? (Excel/VBA)

I have an Excel worksheet that has the following macro. I'd like to loop it every second but danged if …

excel vba