em.
07-14-2008, 02:03 AM
Hello all,
I?m pretty new to vba so any suggestions/samples would be great. I have a userform created for a fax template that pops up when the template is opened, ready for user entry.
There are three checkboxes on the userform that allow the user to select if the fax is urgent, for review, or for your information.
In the document, I have added checkboxes to match the above three choices (I used the active x controls to do this and named them the same name as the userform checkboxes)
If a user ticks the urgent checkbox in the userform, the checkbox in the document should update to show this choice when the user clicks on the OK button on the userform. I have not been able to find a solution to this though I?m sure it is quite simple.
Many thanks in advance J
I?m pretty new to vba so any suggestions/samples would be great. I have a userform created for a fax template that pops up when the template is opened, ready for user entry.
There are three checkboxes on the userform that allow the user to select if the fax is urgent, for review, or for your information.
In the document, I have added checkboxes to match the above three choices (I used the active x controls to do this and named them the same name as the userform checkboxes)
If a user ticks the urgent checkbox in the userform, the checkbox in the document should update to show this choice when the user clicks on the OK button on the userform. I have not been able to find a solution to this though I?m sure it is quite simple.
Many thanks in advance J