Excel Drop Down List

**kuya_mal** · 09-09-2011, 04:27 AM

Hi Expert,

I'm new here at creating a macro for excel,please bare with me and help me.

here is the scenario.

i have a drop down list (K4) with content 1,2,3,4,5

just would like to ask the macro if I change the content (K4) to any value, i just would like to refresh the excel sheet.

Thanks in advance and Best Regards,

Kuya_mal

**Richard Buttrey** · 09-09-2011, 04:36 AM

Hi,

In the SheetChange event add the code

Please Login or Register  to view this content.

Regards

**kuya_mal** · 09-09-2011, 05:00 AM

Hi,

one more thing, i can have a full request, from the sub () up to end sub (), do i need to create a module or i will just write only to the sheet?

regards,

kuya_mal

**Richard Buttrey** · 09-09-2011, 05:17 AM

Hi,

This is a Worksheet_Change event so the code must be added in the Sheet object not a Module.

Regards

**royUK** · 09-09-2011, 08:29 AM

What kind of drop down?

**kuya_mal** · 09-11-2011, 11:01 PM

Hi,

Its a drop down list from "data validation" of excel 2007

regards

**kuya_mal** · 09-11-2011, 11:03 PM

Hi Richard,

Just would like to request the full script for this, i did copy the script you gave to me, but nothing happens.

thanks and best regards,

kuya_mal