Hi There
The macro that I'm trying to create is more complex that what I explain below. What I expalin below is very simple. If I can do that, then I can do my complicated macro.
Suppose I have a checkbox1 in sheet 2 in cell A1. Beside this check box, I have the word Semi Detached in Cell B1. In sheet 1, in Cell A1 I have a dropdown list (Single, Detached, Semi Detached, towns). Now here is what I want to do. If I choose Semi Detached in sheet 1 from the dropdown list, I want the checkbox1 in cell A1 beside the word Semi Detached to be checked. Now in sheet 2, I have another box checkbox2 in cell A2 and beside that checkbox2 I have the word Detached in Cell B2. So, If I choose Detached in Sheet 1 from the dropdown list I want the macro to uncheck checkbox1 and check checkbox2. This procedure is repeated for the other names in the dropdown list. Do you get the picture??
Thanks,
Mario
The macro that I'm trying to create is more complex that what I explain below. What I expalin below is very simple. If I can do that, then I can do my complicated macro.
Suppose I have a checkbox1 in sheet 2 in cell A1. Beside this check box, I have the word Semi Detached in Cell B1. In sheet 1, in Cell A1 I have a dropdown list (Single, Detached, Semi Detached, towns). Now here is what I want to do. If I choose Semi Detached in sheet 1 from the dropdown list, I want the checkbox1 in cell A1 beside the word Semi Detached to be checked. Now in sheet 2, I have another box checkbox2 in cell A2 and beside that checkbox2 I have the word Detached in Cell B2. So, If I choose Detached in Sheet 1 from the dropdown list I want the macro to uncheck checkbox1 and check checkbox2. This procedure is repeated for the other names in the dropdown list. Do you get the picture??
Thanks,
Mario
