Search results

Hello, Dave, Apologize for the technical terminology about pointers! Kindly, allow me to use the following example to describe the meaning of pointers (as elements of an array): Dim ii, j As Integer Dim MyArray(1 To 10) j = 1 ’ j is a (memory) pointer. For ii = LBound(MyArray) To...

Hello, Dave, These 5 references looks great without any conflict - so, I arrive into conclusion that (at this point) I don’t observe something weird! Regarding V.B.A. code, many times when we are trying to set a value (e.g. 0) into a variable (e.g. Foo) by typing: set Foo = 0 we forget to...

Hello, Dave, Thank you for your prompt response! As “outdated reference”, I mean the loaded library (.ocx, .dll, …etc.) to your xlsm file (you can find it under the default menu: VBE=>Tools=>References) which is disabled, or visible as a strike-through text. In this case, you have to re-install...

Hello, Dave, From technical perspective, I think it’s a good strategy, to: 1.) check if the specific (.xlsm) file is blocked by Windows. In this case, before you open this file, you may right click on it, select “Property”, check “Unblock” checkbox, click on “Apply” and then on “OK” button...

Hello to everyone! I would like your opinion about a very weird issue I have. I wrote a V.B.A. script that writes directly in the registry adding a new key (HKEY_CURRENT_USER\Software\ [New Key]). As an xlsm file everything running perfectly, as a standalone exe file (using the trial version of...