Passing a value in VBA using an offset

  • Thread starter Thread starter Roscoe
  • Start date Start date
R

Roscoe

I have code that executes when I double click on a cell. The code
inserts the data validation source into a combobox to ease the input
choice. It refers to the cell I double clicked as "target"

I want to add a new feature. Before anything else happens, I want to
filter the data validation source (many of the entries are for dates
that don't apply. the cell above "target" has a date. I want to copy
the month of that date into a fixed cell ("A1") and then use that date
in an advanced filter on the data validation source. Hope you're with
me so far.

The part I can't figure out is how to use the offset function to
calculate the month from the date in the cell above (the rest of the
code I stole :) and is easy).

thanks
 
Month(Target.Offset(-1,0).Value)

is what I think you mean

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Back
Top