------ Register to get rid of these "In Post" ads! ------


I thought I had it in now, with a new code, but I came across another problem. In the part of the code where it adds to the dropdown menu in a particular cell, how would I edit it to have it so that I select a range of cells in a particular column (each cell in that range has a dropdown menu) instead of selecting only one cell. For example, in the code, "Activesheet.Range("A1")," selects A1 cell of the active sheet, but I want to select a certain range of column C (e.g. C11:C35). How would I accomplish that? In the code, I inserted Activesheet.Range("C11:C35") but the addition of new items in the dropdown menu does not occur and the list also does not get updated with the new item. What am I doing wrong? I am attaching the actual document I am working on. I highly appreciate your help. Thank you.
--- Automerged consecutive post before response ---
I figured out the solution for the problem in my post before this one. Now I have a new requirement, if someone can please help me, as I have a deadline tomorrow for sure.


The new items I add in the menu will need to be recognized as new additions to the list later on. Is there a way I can code the new additions to the dropdown menu as bold fonts or do something to differentiate them from the items already existing in the list? Thank you again.

Keith.

Attached Files

TANF_-_Requirement_Gathering_Template_(Final).xls (310.5 KB, 0 views)