how to wirthe the program below in Visual basic.?

Question

how to wirthe the program below in Visual basic.?

in visual basic, let's say
when cellx = 0, then celly is also 0 (copied from cell x)
when cellx turn to 3(>0) , celly also turn to 3 (also copied from cellx)
but when cellx turn back to 0 or less than 0
let's say cellx = 0 (turning back again from 3)
celly remain 3 (not copied from cellx, just remained as it is)
so, when cellx = 0 , celly = 3 (celly must remain >0)

eg. cellx = 0, then celly = 0 (first step)
cellx = 3, then celly = 3 (second step) (cellx turn to >0, and celly follow suit)
cellx = 0, then celly = 3 (third step) (although cellx turn back to 0, celly must remain at 3 (>0) )
hope it is clear what i want to know. please find me the answer.

Answer 1

'How this works:
'dont_return holds the dont return status
'if the dont_return is false then we can change the cellx
'if the dont_return is true then we can not change the cellx
'This will work once in the program. If you wish to reset the
'functionality you will have to reset the dont_return value back to
'False


'Make a command1 button and place under the code
Sub command1_click
'under your first Form1.Load or similar or where you initalize
'your variables place this (or from the original calling point)

dont_return = False ' Our value can change at this moment

'here you place a value for cellx just for test
cellx=2
f=setcelly(cellx)
End Sub

'Under a module or your calling form place and call this

Function setcelly(cellx)
if cellx=0 and dont_return=False then celly=0
if cellx>0 then celly=cellx:dont_return=True
End function

'Under a Module place this
Global dont_return

I hope this helps
Stefanos

Answer 2

If Cellx <= 0 then GoTo Line1
Celly = Cellx
Line1:


Hope this helps

Answer 3

Learn it yourself here is the link

http://cuinl.tripod.com/tutorials.htm

and furthermore do not use goto fuction like person say above. Use label. Implement like this

If Cellx <= 0 then mylabel
Celly = Cellx

mylabel:
your instructions
end sub

Answer 4

You might want to try vbforums.com. I am sure there are people there that can help you with what you need. Just explain it a little more clearly.

Good luck!

Answer 5

don't know sorry