newbie needs some VBA help

[Mike]

I never done VBA programming EVER. but I need to and not sure how to do it.

Heres the problem.
I have a word template that has a field(s) that allow dollar amounts $0.00.
The problem is that sometimes the user can enter a Percentage but if they do
that it shows as $0.
How can I allow this field to allow percents 4% of dollar amounts %19.99?
I know i can change the property format field, but the users like the $ be
prefilled.

is it even possible to allow a field to allow both?
If possible can someone point me to an example or something to help me with
this?

 

[JGM]

Hi Mike,

What are you trying to achieve?
Will the field be used for calculations?
VBA may not be necessary...

Normally, a field can have only one format.
I do not understand

How can I allow this field to allow percents 4% of dollar amounts %19.99?
I know i can change the property format field, but the users like the $ be
prefilled.

???

You say users like to have the dollar symbol preformatted... so why are they
entering %? Give us an example or explain the context then I am sure someone
will comme around with something you can use...

Cheers!