asked on

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

SiddharthRout

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

ASKER CERTIFIED SOLUTION

SiddharthRout

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Bright01

ASKER

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.

Bright01

ASKER

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.