VBA codes fail to run automatically ~~

[timesareGMT]

Hi all,

I set up the VBA codes as below:

Sub AGG_CEM()
Select Case Trim(Range("e6").Value)
Case "Present"
Rows("12:24").Hidden = False
Rows("25:48").Hidden = True
Case "Absent"
Rows("12:24").Hidden = True
Rows("25:48").Hidden = False
Case Else
Rows("19:48").Hidden = False
End Select
End Sub

I plan to set it run automatically by the combo box selection, but actually it fails and I need to press ALT+F8 to get it work.

What was going wrong?

Thanks.

 

[Misca]

Your code should work just fine as it is as long as you've got your E6 value right:

Excel Workbook
	E
1	Present
2	Absent
3	Whatever
4	*
5	2
6	Absent
Sheet

In my example I have the drop down list values in E1:E3 and the drop down list changes the value in E5. E6 houses the INDEX returning the actual value that I've chosen in my drop down list.