Dim vUkrSimbol As Variant, vLat2UkrReplace As Variant
Sub Initialize
Dim UkrSimbol As String, Lat2UkrReplace As String
UkrSimbol = "ій,є,є,ї,щ,зг,ж,я,я,ю,ю,ш,ч,ц,х,ж,а,б,в,г,г,д,е,з,и,і,к,л,м,н,о,п,р,с,т,у,ф,
с,й"
Lat2UkrReplace = "iy,ye,ie,yi,shch,zgh,zh,ya,ia,yu,іu,sh,ch,ts,kh,zh,a,b,v,h,g,d,e,z,y,i,k,l,m
,n,o,p,r,s,t,u,f,s,j"
vLat2UkrReplace = Split(Lat2UkrReplace, ",")
vUkrSimbol = Split(UkrSimbol, ",")
End Sub
Function String2Ukr(sArgum As Variant) As Variant ' Конвертирование латыницы в украиницу
Dim k As Integer, s1 As String
s1 = Lcase(sArgum)
For k=1 To Ubound(vUkrSimbol)
s1 = Replace(s1, vLat2UkrReplace(k), vUkrSimbol(k))
Next
String2Ukr = s1
' String2Ukr = Replace(Lcase(s1), vLat2UkrReplace, vUkrSimbol)
End Function