i have a userform populating form fields in a document. one of the
form fields needs to be the userform textbox, txtnumber, but written
out (i.e., three hundred seventy-five). i found on the web a macro
that will do this. but i'm having trouble making it run from within
the userform code.......... at this point i've got it in a different
module; thought that might help.
xxxxxxxxxxxxxxxxxxxxxxxxxx
ActiveDocument.FormFields("inumber").Result = txtnumber
ActiveDocument.FormFields("sadjective").Result = txtadjective
If txtnumber <> "" Then
Run newmacros("cmdBigCardText")
Else
Exit Sub
ActiveDocument.FormFields("swritten").Result = sBigStuff
xxxxxxxxxxxxxxxxxxxxxxxxx
the error i get when compiling is:
"expected variable or procedure, not module"
what is the syntax for calling in another macro? cmdBigCardText is a
private sub.... maybe it should be public?
thanks for your help!
susan
Susan - 04 Oct 2006 13:12 GMT
*duh*
i found out i can format the field to display in cardinal
text..........
convert number to cardinal number
http://office.microsoft.com/en-ca/assistance/HP051862221033.aspx
thanks for NOT replying! ha ha as it made me look harder to find a
work-around.
posting link in case somebody ever searches for this same thing.
susan