I'm having trouble with what might seem to be simple coding for the seasoned VBA pro. What I want to do is have a number entered like 127 and then have it show as text like One Two Seven. Can any one help me out. My example code is below.
Dim MyNumber, MyText
MyDouble = 127
MyText = CStr(MyDouble)
I'm new to VBA and I thought the Cstr statement will convert the 127 to one- two -seven but it actually takes the integer 127 and displays it as 127 in string format. Again I want to show text One- Two- Seven. Any help would be great, this has been taking me days to figure out.
Dim MyNumber, MyText
MyDouble = 127
MyText = CStr(MyDouble)
I'm new to VBA and I thought the Cstr statement will convert the 127 to one- two -seven but it actually takes the integer 127 and displays it as 127 in string format. Again I want to show text One- Two- Seven. Any help would be great, this has been taking me days to figure out.
