Search code examples
stringexcelvbaudf

Excel WBA UDF to manipulate string doesn't work


My UDF in VBA is complaining about invalid qualifier and I don't understand why.

enter image description here

Thank you in advance for your help.


Solution

  • VBA string does not have a Chars() modifier. use MID(Trans,i,1) instead