1 Attachment(s)
Radio Button matters...Words VBA
Dear All Experts,
Has anyone could help me please. I create a debit / credit table in a word document using blank fields inside rows to be filled out on the VBA. The shymptom is like this, if I click each radio button (DEBIT) then it will write on each Field "DEBIT" on the word document, if I click on CREDIT radio button, it will write "CREDIT" or if I leave it blank, it will do nothing (result is a blank field). Anyone knows how to code this problem please...please...I was really stack to think about this..Beside, please find my attached document (click on Macro inside Ms Words and using VB Editor) then there is very small dummy program there...to make you easier to help me)...
Thank you very much for your fully kind assistance and helps...
Jennifer ;)
1 Attachment(s)
Re: Radio Button matters...Words VBA
Hi,
P.S the attached word file to see the vba code.
And, Also find the macros (module) in the vba code. I think it is better to use macro procedures instead of using userforms.
CS.
Re: Radio Button matters...Words VBA
Hi,
Thank you very much for your kind helps...thanks...thanks...However, I could not see the result first since the macro for that project is disabled...Do you know how to disabled macro please? Because I tried to select "Security" on the drop down of Macro menu, and set to "Low" but still ...the Macro was Disabled....
Thanks,
Jennifer ;)
Re: Radio Button matters...Words VBA
How you are saying the macro is disabled?
I think you need to call that userform using show method in a procedure. like
userform1.show
CS.
Re: Radio Button matters...Words VBA
Dear CS.
What should I do, if the shymptom like this:
If I open that file (Test01-1.Doc), it will automatically load/show that form (UserForm1), be ready to fill it out....& where should I put it the code please..??..would you please help me..?? :)
Thanks very much for your kind helps...
Best Regards,
Jennifer ;)
1 Attachment(s)
Re: Radio Button matters...Words VBA
Hi,
If you want to show that form automatically when you open that document, put your code in auto open procedure. See the attached document for more details.
Open the vba editor and double click "ThisDocument", and see the code.
CS.
[Resolved] Radio Button matters...Words VBA
Hi,
Thanks for your all kind helps...It works now..!!!
All the best for you,
Jennifer