how do i read a parameter for my function?

[kenguru]

Does anyone know how can i read a parameter for my function (for example from which line has to start my for cicle) without using a 'form'?

Thank You,
Kenguru

 

[GlennUK]

What have you got so far please? ( and what is cicle? )

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[xlbo]

Not sure what you mean. Standard way to pass params is:

Sub Call_Function_Example()
dim myVar as string

myVar = Range("A1").text

Call thefunction(myVar)

End sub

Function theFunction(VariableTest) as string
'Do stuff with 'VariableTest' which will be = myVar
theFunction = Result
End Function

 

[kenguru]

I found a way: using inputbox

 

[fumei]

Huh??????? But....OK...glad something is working out there.

Gerry