call function that written in form from module

[kirubagari]

Dear expert,

i had written the code in my form

Public Function HoldType(ByRef sType As String) As String
 
If bOkClicked Then
 sType = "Rehold "
End If
 
If bOk1Clicked Then
sType = "MultipleHold"
End If
 
End Function
 
 

i want to call it in my module as below

Public Function HoldReleaseLot(sActionType As String) As String
 
Call HoldType ()
 
 

i unable to perform this..What is the method calling function that written in form in module

Kindly help

[MikeTheBike]

Hi

You do not indicate what application you are running the code in, but, on the basis that the form is open, then, if its Excel or Access (and I suspect .NET or any other language?) then you need to refer to the form Object/Class by name something like this

In Excel

Public Function HoldReleaseLot(ByRef sActionType As String) As String
    UserForm1.HoldType sActionType
End Function

In Access like this

Public Function HoldReleaseLot(ByRef sActionType As String) As String
    Form_YourFormName.HoldType sActionType
End Function

OR like this

Public Function HoldReleaseLot(ByRef sActionType As String) As String
    Forms("YourFormName").HoldType sActionType
End Function

HTH

Note sure what the ultimate doing, but as it stands both HoldType and HoldReleaseLot could be a Subs rather that a Functions!?

MTB