Hi Guys,

I want to fetch last word from a entered string and then I have to store it in some variable. HOw can I do that in VBA?
For example:
Suppose I have entered String as: Universe\Planets\Earth\A\
from above string I have to fetch only A. My entered string will have delimiters like \ or /.

How can I do that in VBA, I tried a lot but did not get success. Also checked in different forums and MSDN... but not found.