Run macro everytime cell content changes

[nrage21]

Hi SuitedAces,

Instead of starting a new thread to post my own problem, I decided to reply to this particular post, since I am basically trying to re-use the same code.

My problem is that the procedure does not fire. I have a validation list which feeds cell a43 (a named cell/range). Anyhow, based on the selection, the cursor should move to the specified cells. I am using excel 2k3. Macro security has been set at medium. I am thinking that perhaps I have a visual basic project "reference" turn off or something. Could you help? I am attaching the spreadsheet and the sheet code for reference. Rows above 43 are hidden... that's where I have place my lists.

Please Login or Register  to view this content.

Thanks in advance, I am sure you will be able to spot the mishap in a sec.

Regards,
nrage21

[VBA Noob]

nrage21,

Please read forum rules below. I've moved your post to it's own thread

I've changed your ref to A47 which will trigger the event when the dropdown changed. Also when using Lcase function the dates have to be lower case (You had proper case dates). If you want a formula to trigger the event you should look at using a

Please Login or Register  to view this content.

event

Please Login or Register  to view this content.

HTH

VBA Noob

[Leith Ross]

Hello nrage21,

I also looked over your code and made a few changes. I extended your range from A43 down to tthe last cell used in column "A", otherwise your test will only work for row 43. The Application.GoTo statement is necessary if you are only selecting a cell. See the code.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[Leith Ross]

Hello nrage21,

I also looked over your code and made a few changes. I extended your range from A43 down to tthe last cell used in column "A", otherwise your test will only work for row 43. The Application.GoTo statement is unnecessary if you are only selecting a cell.Also, Data validation will not trigger a Worksheet_Change event, only a Worksheet_Calculate event.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[nrage21]

Thanks so much guys for such quick responses.

All the codes worked perfectly, and I learnt some of the criteria required when using Worksheet_Calculate and Worksheet_Change events.

Very grateful indeed.

Regards,
nrage21