Well i guess ill start with what code i have and work from there...
zNum = 0
x2 = 0
y2 = 0
z2 = 0
Do
Do
Do
myArray(x2, y2, z2) = zNum
If zNum = txtNum.Text Then
GoTo subEnd
End If
z2 = z2 + 1
zNum = zNum +...
ok i have 1 column say "A" that is about 50 rows long and each cell has to be a unique number say 1 to 50.
if there is a repeat number somewhere in the column how can i, using a button, search down repeats and make the value the next largest number in the column (eg. 51) then keep searching...
what i need is to have the button (forms) count the number of times it has been pressed and only allow it to be pressed a certain number of times like 5 times for instance. then ill have it spit out a msgbox or something. i tried a couple things but im pretty new to VBA and didnt produce the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.