Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Variable Sum Function | Excel Discussion (Misc queries) | |||
Variable function | Excel Discussion (Misc queries) | |||
Variable function | Excel Discussion (Misc queries) | |||
Using variable in a function | Excel Programming | |||
Set variable to a function | Excel Programming |