View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
ben ben is offline
external usenet poster
 
Posts: 232
Default 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