PDA

View Full Version : Excel VBA Help - hide few fields on drop down selection



gauravgupta
01-30-2008, 11:45 PM
Hi,

Find a form attached with this post (Form1.xls)

On the basis of what I select in E11 few rows should get hidden.
For Example:

If I select either "E-Learning" or "Self-Certify" in E11(Item_Type)
Rows 32:38 should automatically hide.

I'm not able to achive this as its giving me some or the other error.

If anyone can spend sometime on this then i will be greatful.

Thanks.

you can alternativly send me solution on either gaurav.hyd@gmail.com or bunty.gupta@yahoo.com.

:)

shades
02-01-2008, 07:51 AM
Howdy and welcome to the board.

Just to clarify: Is this specific to Mac version(s) of Excel?

tpoynton
02-01-2008, 12:40 PM
I'm not getting an error in excel 2007, but it's not doing anything either. Further, I dont see any code to hide the rows anywhere, from my quick look. I'm not familiar enough with the dropdown list on a worksheet to even know where to begin.

not enough info, it seems, to figure out if it's mac specific or not!