Search:

oh!...
i didn,t notice that ... 11 years...
Sorry! I thought this was a VB6 thread.:)

This function returns alphabet/alphabet-series-string from a specified number.
For example :
GetAlphaString(26) ---returns---> "Z"
GetAlphaString(27) ---returns---> "AA"
GetAlphaString(28)...

try this to replace beta:

activecell.Replace chrw(946),"beta"

I cannot fix this issue. But I found a mistake...

The used sybol is β but ASCII Code 223 is for ß.

ß = ASCII (Decimal) 223
β = Unicode (Hex) 03B2

Check it in the 'Insert > Symbols" window...

I'm not an expert in VB. Try this code. this may help you.



Public Sub ExtractNumbersToTextbox(SoureTestbox As TextBox, DestinationTextbox As TextBox, minValue As Integer, maxValue As Integer)...