Vba in word

[webstp01]

I have the VBA below in excel that will write numbers in words by using =SpellNumber(A1). I now want to do the same thing in word so ive pasted the same VBA in word but am now a bit confused on how i programme the document to say which bit it should be spelling out. I have tried 'toggle field codes' but not quite sure what to put in there. If anyone can help, it would be much apprieciated. Thanks

Please Login or Register  to view this content.

[protonLeah]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[macropod]

Toggling field codes won't do anything to run a macro. You need an event for that, such as exiting a formfield or content control, or double-clicking on a MACROBUTTON field. The latter would also require you to use an inputbox to solicit the amount to convert.

In any event, Word provides the same functionality via field coding (e.g. http://answers.microsoft.com/en-us/o...2-3ab302c9514b), so that you don't need to use either your vba functions or any of the above methods. Until you provide more information on exactly how you're trying to supply the amount to be converted, no-one can give specific advice as to the best approach.

[webstp01]

I have tried using the field coding in http://answers.microsoft.com/en-us/o...2-3ab302c9514b but this is only useful if the amount hasnt got a decimal so its not what im looking for.

Basically i have an excel spreadsheet where a user will enter an amount. Using the VBA coding above i was then able to use the spellnumber formula to covert it into words. Both of these cells will be pulled into a word document.

Im trying to stay away from doing things in excel and start coding it in the word document itself.

Ive been told you can use VBA in word documents but dont really understand what i need to do to get it working. I was wondering if anyone can help with an easy step by step instructions as I'm not good at this type of thing. I get most formulas/coding from copy and pasting from google.

[macropod]

I have tried using the field coding in http://answers.microsoft.com/en-us/o...2-3ab302c9514b but this is only useful if the amount hasnt got a decimal so its not what im looking for.

That simply isn't true. The field code I posted there most certainly caters for cents - you can even see the reference in the field code if you read it. Depending on what you're doing no macros of any kind are required for this in Word!

[webstp01]

That simply isn't true. The field code I posted there most certainly caters for cents - you can even see the reference in the field code if you read it. Depending on what you're doing no macros of any kind are required for this in Word!

Well it doesnt seem to want to work for me!

[macropod]

In this case, you haven't created the field code properly. What did you do to recreate the field in your own document?