View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Help with Macro - Make Dropdown List Temporarily Wider

The key is the fourth line. The code looks for column #4 (column D ). Lets
say we want the code to work on both column D and column J. Instead of:

If Target.Column = 4 Then

use:

If Target.Column = 4 OR Target.Column = 10 Then


--
Gary''s Student - gsnu200717