Getting an error in VBA compiler

excelvbaisfun

excelvbaisfun

New member
Hi @gdgsupport and ALL,

When trying to play with the VBA compiler, I was following the steps outlined in the video here:
To view this content we will need your consent to set third party cookies.
For more detailed information, see our cookies page.

and when I tried to run the =ten() function on a worksheet cell, it gave me this error:

This error occurred in the VBA compiled code: “Access violation at address 221F6B92 in module ‘GXLSForm.dll’. Read of address 0000010C”. Please open the VBA compiler of XLS Padlock and recompile your code.

image

I had inserted this into the VBA Compiler and clicked ‘Compile’
image

I have the following in the VBE in excel:
image

I don’t know where I’ve gone wrong. It’s probably a simple syntax issue but have I done something wrong?

Thanks

Dan
 
Last edited:
UPDATE
After thorough testing, it seems this does work when compiled into a protected app, but it doesn’t work for me at design time (when in regular excel program).

so for some reason this statement doesn’t apply for me (from the documentation):
If you click Run to execute calculate() in VBE, calculate() sub still works, even if you replaced it. It is because XLS Padlock can execute protected code even at design time.
Click to expand...
Anyone know why I can’t executed compiled VBA code at design time in order to test it more quickly?

Also, did I mention lately that I love this software?! It is awesome, despite questions that sometimes arise. This software enables anyone to be a software developer and sell apps that are legit protected so BIG TIME THANK YOU FOR ALL THAT YOU DO, @gdgsupport!!

Thanks

Dan
 
The video is outdated. You should try:
Code: 
Function ten(x)
ten = x + 10
End Function
We have plans to release an updated video when XLS Padlock 2019 is out.
 
You must log in or register to reply here.
Back
Top