using a variable in a function
 

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

using a variable in a function
 

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

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