running a sub
 

ok, please dont delete this, i dont know where else to turn:( but it
isnt about excel, it is VBA in access (i dont know if there is any
difference) i have this:

Code:
--------------------

Private Sub DateBorrowed_AfterUpdate()
'get it to run Fine_GotFocus()
End Sub

Private Sub Fine_GotFocus()
'do stuff
End Sub
--------------------


how do i "'get it to run Fine_GotFocus()"?


---
Message posted from http://www.ExcelForum.com/

running a sub
 

Assuming Fine_GotFocus is visible to DateBorrowed_AfterUpdate, this should
work.

Private Sub DateBorrowed_AfterUpdate()
Fine_GotFocus
End Sub

You might have to declare Fine_GotFocus as public instead of private

Public Sub Fine_GotFocus()
'do stuff
End Sub

if they are in different modules, you might need to preface with the module
name.


--
Regards,
Tom Ogilvy


"Ghell " wrote in message
...
ok, please dont delete this, i dont know where else to turn:( but it
isnt about excel, it is VBA in access (i dont know if there is any
difference) i have this:

Code:
--------------------

Private Sub DateBorrowed_AfterUpdate()
'get it to run Fine_GotFocus()
End Sub

Private Sub Fine_GotFocus()
'do stuff
End Sub
--------------------


how do i "'get it to run Fine_GotFocus()"?


---
Message posted from http://www.ExcelForum.com/