hey guys, me again, im almost done writing this application but the problem is is that the value of my variable nummarks is not being used globally. it simply gets set back to 0. attached is my program. help would be muy bien
hey guys, me again, im almost done writing this application but the problem is is that the value of my variable nummarks is not being used globally. it simply gets set back to 0. attached is my program. help would be muy bien
It is declared in a userform's code module. It will go to zero when the userform is unloaded.
is there a way i can still do it? because i need to unload the form so that i can write stuff in the cells.
You don't need to unload the user form first - populate your cells, then unload the form.
All of your code is in the userforms code module, if the UF is unloaded, your code doesn't run.
I don't get it. You create the table. You can add values okay. Whyt do you need to get the variable afterwards?
and the average calculation is a bit awry.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Yeah ! but you're slower than Speedy ... and he's only a mouse ...Originally Posted by xld
2+2=9 ... (My Arithmetic Is Mental)