using a variable in a function
Thanks
Alvin
"ben" wrote:
your variable is only public within the form, if the function is in a
seperate form OR module then the function creates a new instance of the
variable.
Try sharing your variable as public in a Regular Code Module as Public, This
will share it for the whole Project.
Also see VBA on 'Life of Variables'
--
When you lose your mind, you free your life.
"alvin Kuiper" wrote:
Hi
i have this
Public antal As Integer ' in decalration in the form
then i have this in a command button
antal = DateValue(sdage.Value) - DateValue(dage.Value)
antaldage.Value = antal
Its working
Now i want to use the value of antal in a function , i run in another comman
button
But here it is emty Why???
resgards
Alvin
|