Highlight Cells Based on Drop Down List Selection
Solved/Closed
wliang
Posts
41
Registration date
Thursday June 16, 2011
Status
Member
Last seen
May 7, 2014
-
Oct 3, 2012 at 02:59 AM
wliang Posts 41 Registration date Thursday June 16, 2011 Status Member Last seen May 7, 2014 - Oct 8, 2012 at 07:58 PM
wliang Posts 41 Registration date Thursday June 16, 2011 Status Member Last seen May 7, 2014 - Oct 8, 2012 at 07:58 PM
Related:
- Highlight Cells Based on Drop Down List Selection
- My contacts list names - Guide
- How to change your best friends list on snapchat to 3 - Guide
- Counter strike 1.6 cheats list - Guide
- Whatsapp country code list - Guide
- Huawei secret codes list - Guide
4 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Oct 4, 2012 at 12:55 AM
Oct 4, 2012 at 12:55 AM
I did debugging your event code.
where is the target. from the validation arrow in sheet "summary 1 it looks it is in the column F which is column no.6
if you write target.offset(0,-6) this is error because it goes to the left of column A.I do not know whether you are thinking (0,-5)
(offset to step back or forwards)
in the immediate window if you type
?Target.Offset(, -5).Resize(, 5).Address
and hit enter key you will get
$A$4:$E$4
I think this what you are thinking
note offset is minus five and resize is +5(or +6)
you try with this modification.
where is the target. from the validation arrow in sheet "summary 1 it looks it is in the column F which is column no.6
if you write target.offset(0,-6) this is error because it goes to the left of column A.I do not know whether you are thinking (0,-5)
(offset to step back or forwards)
in the immediate window if you type
?Target.Offset(, -5).Resize(, 5).Address
and hit enter key you will get
$A$4:$E$4
I think this what you are thinking
note offset is minus five and resize is +5(or +6)
you try with this modification.
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Oct 3, 2012 at 05:32 AM
Oct 3, 2012 at 05:32 AM
IS this not something like nested if and in some version maximum is 7. check whether this is the problem . I remember seeing in the web some way to get out of the situation
wliang
Posts
41
Registration date
Thursday June 16, 2011
Status
Member
Last seen
May 7, 2014
Oct 3, 2012 at 07:45 AM
Oct 3, 2012 at 07:45 AM
Hi venkat1926,
Thanks for your response. I have checked the nested if and tried to limit the selection to 3 but still having the same error. I tried searching in the Web on this but can't get much info.
Is it possible to change the code? Instead of putting them directly into a worksheet, is it possible to create them into a module? Any other way to do this highlighting a row based on selection from drop down list?
Please advise. Appreciate your help on this.
Thank you.
Best regards,
wliang
Thanks for your response. I have checked the nested if and tried to limit the selection to 3 but still having the same error. I tried searching in the Web on this but can't get much info.
Is it possible to change the code? Instead of putting them directly into a worksheet, is it possible to create them into a module? Any other way to do this highlighting a row based on selection from drop down list?
Please advise. Appreciate your help on this.
Thank you.
Best regards,
wliang
wliang
Posts
41
Registration date
Thursday June 16, 2011
Status
Member
Last seen
May 7, 2014
Oct 8, 2012 at 07:58 PM
Oct 8, 2012 at 07:58 PM
Hi venkat1926,
Thanks for your advice. I have tried some modifications on the codes and it seems to work fine now.
Once again thanks for your help.
Best regards,
wliang
Thanks for your advice. I have tried some modifications on the codes and it seems to work fine now.
Once again thanks for your help.
Best regards,
wliang