asked on

Problem finding correct place for code

Folks,
I have tried to work through the code on the list box "Topics" where the user double- clicks on the Topic so it takes them directly to the desired worksheet. I've tried to execute the GoToSelect module in the double-click event so I could then delete the command button GotToSelection rather than hide this command button.
Financial-Analysis-Revised.xlsm

Martin Liss

I don't understand what you are asking. When I double-click one of the topics it goes to the associated sheet. What do you want to do differently?

SOLUTION

Norie

membership

This solution is only available to members.

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

Start Free Trial

Norie

Actually that won't work because there's something else, well perhaps more than one thing, going on.

PS Why a Click and DblClick for the listbox? They actually appear to be clashing.

Frank Freese

ASKER

Martin & Imnorie,
When I first started this project (from another workbook) the user could click on a Topic and it would go to another section on the worksheet where the user could click on the command button "Go To Selection". Later it was suggested just double-click on the Topic list box . I've since eliminated everything below the two list boxes and text box and just having the user double-click on the Topic. I've bounced all around trying to make this work. So what I did was simply keep the command button Go To Selection but made it invisible. That's not very good design. I even created a module modGoToSelection and placed that in the double-click event for the Topic list box. I get this error:

I've included the file that this error appears.
Financial-Analysis-Revised.xlsm

ASKER CERTIFIED SOLUTION