Annabel
07-19-2005, 05:31 AM
Hi All
I have a workbook with several sheets. The first sheet have combo boxes with pass values to hidden fields on sheet 2.
On sheet two these values pass text (Yes for 1, No for 2) to a column of fields.
Ideally where the field is Yes (value 1) I would like sheet three to become unhidden. This will need to be repeated for each of the cell in the range that have text of YES.
Can anybody help. I've attempted to create a macro but with little success as I'm not very good in VB and don't know how to trigger the event.
I've attached the workbook in case that helps
Thanks
Annabel
I have a workbook with several sheets. The first sheet have combo boxes with pass values to hidden fields on sheet 2.
On sheet two these values pass text (Yes for 1, No for 2) to a column of fields.
Ideally where the field is Yes (value 1) I would like sheet three to become unhidden. This will need to be repeated for each of the cell in the range that have text of YES.
Can anybody help. I've attempted to create a macro but with little success as I'm not very good in VB and don't know how to trigger the event.
I've attached the workbook in case that helps
Thanks
Annabel