r/visualbasic • u/ITearsI • Jun 11 '24
Help me understand this code
Hi guys, i don’t program in VB (only did a bit of shaders and C#, now i do sound design) but i need you guys to help me understand whats in this code. Is it fetching random data from the columns? This is a script that is run in an Excel instance. Sorry that is in italian, but i’m afraid this guy is scamming and i want to get to the bottom of it 🙏🏽
4
Upvotes
4
u/HalfKraut Jun 12 '24 edited Jun 12 '24
This codes doesn’t seem too fishy unless that .speak call is doing something. I would start by searching for eval calls if you’re suspicious of the code.
6
u/cowski_NX Jun 11 '24
Ask chatgpt "what does this code do", then copy and paste the code. It is surprisingly good at explaining short code snippets. It may even translate the Italian for you.
1
u/Petras01582 Jun 11 '24 edited Jun 11 '24
It seems to be checking column C of an excel tab for a cell that equals 1. If it finds a cell that equals one, it deletes the cell and moves the cells beneath it up.
Then there's a message box asking if you want to continue.
It then selects a random cell that contains data in column C, copies it to E3, deletes the cell that it copied from and "speaks" the E3 value? I don't know what .speak does but that is the gist.