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 I say Is Not Null in VBA

Hi I have the following expression. I'm trying to say "if the second field Is Not Null". Can you help. …

Read More
ms-access null vba
Continue For loop

I have the following code For x = LBound(arr) To UBound(arr) sname = arr(x) If instr(sname, "Configuration item") …

Read More
vba loops for-loop next
How to check for empty array in vba macro

I want to check for empty arrays. Google gave me varied solutions but nothing worked. Maybe I am not applying …

Read More
vba excel
What does the keyword Set actually do in VBA?

Hopefully an easy question, but I'd quite like a technical answer to this! What's the difference between: i = 4 and Set …

Read More
vba variable-assignment
VBA Check if variable is empty

I have an object and within it I wanna check if some properties is set to false, like: If (not …

Read More
vba object variables is-empty
Excel VBA Password via Hex Editor

I have used the "Hex Editor to modify DPB to DPx" many times in the past to bypass VBA project …

Read More
vba excel hex-editors
Getting around the Max String size in a vba function?

The max number of characters you can use in string in a vba function is 255. I am trying to run …

Read More
ontime excel vba
Show "Open File" Dialog

How would I go about showing an open file (or file select) dialog in access 2007 VBA? I have tried using …

Read More
vba ms-access
Convert cells(1,1) into "A1" and vice versa

I am working on an worksheet generator in Excel 2007. I have a certain layout I have to follow and I …

Read More
excel vba cell
VBA: How to display an error message just like the standard error message which has a "Debug" button?

As usual, I create an error-handler using On Error Goto statement, there I put a few lines of cleaning codes …

Read More
vba scripting excel ms-office