Dropdown Option Coding

[balilewis]

Microsoft Excel 2010.

Please help me - I inherited a request form that I maintain. The person who created this form left the company before I was hired.
So basically, the form will hide/show specific rows based on the dropdown item that the user selects.

z9Rle7H.png

So for example, if the user selects GL Account, it will display Rows 23-24, and 525-528. If the user selects Profit Center, it will display rows 33-34 and 834-860.

The last rows of the sheet is row 1086.

I need to add a new option to the dropdown box and also create the form in rows 1086-1100.

However, I'm having trouble with the coding of this form. Taking a look at the code in the sheet right now I'm confused on how the form works because it does not show how if the user selects GL Account, it will display Rows 23-24, 525-528 and so on. Please help!

Please Login or Register  to view this content.

[ptmuldoon]

It appears the dropdown options is doing a filter on the data. For example, what column is GL Account in?

Can you post a sample file?