ComboBox with Data Validation

[GRCArizona]

Hi - I found a macro that displays a Data Validatoin Combo Box using Named Ranges. Right now, it works on ALL cells in the worksheet that have Data Validation, but I would like to customize it to work on only 1 cell (F6).

I've tried to define the Target Range as F6, but I must be doing sth wrong, b/c the macro doesn't work 100% as it should.

Here is what I added:

Dim NRange as Range
Set NRange = Range("F6")
If Not Intersect(Target, NRange) Is Nothing Then

(.....continue Code)

Any help or ideas would be greatly appreciated.

Thanks,

GRC

 

[rs2k]

Can you not just use a validation list in F6?