Readjusting the Output to top position of Column

SiddharthRout has helped me write a brief selection routine using drop down boxes to select the correct choice and then subset the questions.  However, in order to actually implement this, I need help with a problem with the output. If you choose a Category and then type, you will see that it doesn't re-set the subset questions at the top row (I8).  Is there an easy way to always set the questions as you change criteria, to the top row instead of further down the list that's created when you select the first criteria?

B.


Dynamic-Table-Lookupv2.xls
Bright01Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

SiddharthRoutCommented:
I just tested it and it works.

The reason it is not working because your

Application.EnableEvents are set to False.

Paste this code in a module and run it.

Sub EE()
Application.EnableEvents = True
end Sub

Open in new window


now test the file.

Sid
0
SiddharthRoutCommented:
Here is the file.

Sid
Dynamic-Table-Lookupv2.xls
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Bright01Author Commented:
Sid,

"Beautiful"!  This just keeps getting better and better!  I've got to issue another related question to take this to the (hopefully) final level.  Much thanks!

B.
0
Bright01Author Commented:
Sid,

In addition to asking a related question about choices in the dropdown....... when I take the code and include ....in the Module:

Sub EE()
    Application.EnableEvents = True
End Sub

I still have a problem with questions appearing way down the column.  I have to incorporate 400 questions, I get the same error as before.....the questions appear way down the column.  Is there a limitation on column i or something I haven't considered in the ability to bring the questions that are selected to "the top"?

Thanks!

B.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.