Convert To VBA

[PC User]

I have a MS Excel formula in a cell that I'd like to convert to VBA in order to use in MS Access. Would one you experts be so kind as to convert this formula into a VBA function.

=LEN(SUBSTITUTE(C3, " ", ""))

Thank you so much.

 

[Joe4]

Try:

ln = LEN(REPLACE([[I]SomeField[/I]]," ",""))

 

[PC User]

Thanks for your reply. Alternative methods are always nice to have, but there must be a way to translate this into VBA function. For example, what is the VBA equivalent of "LEN()" and what is the VBA equivalent of "Substitute()"?

Gratefully yours

 

[PC User]

Ok. I tried putting it into a function and it worked.

Function LPN(Text As String)    
     LPN = LEN(REPLACE(Text," ",""))
End Function

 

[Joe4]

Ok. I tried putting it into a function and it worked.

Glad to see you figured out I was giving you the VB answer you were looking for!