Macro To Create Border Around Multiple Cells

Hi Everyone,

I am trying to create a macro that will create a border around multiple cells in a single row. Below is the macro I created. I got it to partially work before adding the Else statement, but it still reflected an error in line prior to the Else statement. I'm hoping this is a quick and easy fix, and that it doesn't mean I have to rewrite the macro. I'm hoping that someone might be able to tell me why it won't work as written. I can add an example workbook if necessary to help see what's going on.

HTML Code: 

I appreciate any help that I can get on this. So, thank you in advance for your help.

Matt

Please Login or Register  to view this content.

Porucha vevrku,

Thank you for your help. The code you wrote did add the border when a "topped" item is selected from my pull-down menu; however, it doesn't remove the border when I select a product that isn't topped. How do I modify the code to accomplish this? I did try the Else line below, which was unsuccessful.

HTML Code: 

Thank you, again, for your help.

Matt

Porucha vevrku,

I managed to figure out how to delete the border by changing the Else line to the following:

HTML Code: 

This seemed to do the trick. Thanks for all your help.

Try:

Please Login or Register  to view this content.