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.
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 passwordsI 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-variablesHow can I use regular expressions in Excel and take advantage of Excel's powerful grid-like setup for data manipulation? In-cell …
regex excel vbaHow do I convert the integer value "45" into the string value "45" in Excel VBA?
vba string type-conversion integerI want to find if a string contains a ","(comma) in it. Do we have any other option other than …
string vbaHow 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-valueI would like to exit my for loop when a condition inside is met. How could I exit my for …
excel vba for-loopI'm trying to copy entire column in sheetA to Sheet B. sheetA column has values formed with formuls. I'm copying …
excel vba copy-pasteI just need to activate a certain worksheet. I have a string variable that keeps the name of the worksheet.
excel vbaI have an Excel worksheet that has the following macro. I'd like to loop it every second but danged if …
excel vba