Solved

Additonal functionality after item select from list box

Posted on 2013-12-24
10
224 Views
Last Modified: 2013-12-24
Folks,
The atatched workbook is large, but what I need is an additional functionalty.
When the workbook opens you will see in the Menu tab with two list boxes and a text box titled Category, Topic and Description. Once a Category is selected I can then select a Topic. When a Topic has been select then the Description box is populated.
When a Topic has been selected there is a command button labeld Go To Selection that is enable and a yellow ====> points to the row of the under the heading of Formula and Function as well as Purpose.
The user can click on the command button, the formual and function topic and purpose and go directly to the worksheet. I did not write any of that code but I have tried to work through it to add an additional functionality.
Here's my need. In the beginning a Category is first selected then a Topic. I'd like to have the user double click on the Topic selected to take them to that worksheet while maintaining the Go To Selection, Formula and Function and Purpose to go to the worksheet.
This addition is a lot to ask but I have tried on my own only to fail.
Thanks for you help here.
Excel-Formulas-and-Functions.xlsm
0
Comment
Question by:Frank Freese
  • 5
  • 5
10 Comments
 
LVL 45

Expert Comment

by:Martin Liss
Comment Utility
Let's see if I can help.
0
 
LVL 45

Accepted Solution

by:
Martin Liss earned 500 total points
Comment Utility
Add this to the ConvertInvalid sheet.

Private Sub lstTopic_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
GoToSelection = True
End Sub

Open in new window


Is that what you want?

BTW, I would defiantly change the name of that sheet from ConvertInvalid to something else since it doesn't convert anything.
0
 

Author Comment

by:Frank Freese
Comment Utility
I do not see a sheet named ConvertInvalid? Honestly
I have a command button named ConvertInvalid
0
 
LVL 45

Expert Comment

by:Martin Liss
Comment Utility
ConvertInvalid is the first one in the list and it's the one that says "Menu".

Let me make another suggestion. You have over 100 userforms in the workbook and most (maybe all) of them are pretty much the same except for the contents of Textbox1. Why not just have one userform in which you change the text of textbox1 depending on what you want to show? If you did that I bet your workbook would be smaller.

If you want help in doing that, please create another question.
0
 

Author Comment

by:Frank Freese
Comment Utility
I guess this is another of my senior moments but the workbook I have has no sheet named ConvertInvalid. Did you look at the one I attached?

I'd be interested in opening another question regarding my userforms also. I have many more user forms to create and at one time was wondering if there could be a better way. I'm going through each sheet now and making final changes so this would be a good time to try this.

Back to my question here. Do you remember when asked if I'd like for the user to not only open the worksheet with the command button "Go To Selection" but also to the right of the yellow ====> they could also open the select sheet?
What I was wondering was in the very beginning on the "Menu" tab in the list box under Topics that if a user double clicked on the topic it would also send them directly to the worksheet. I don't think the solution presented is what I am looking for.
0
Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 45

Expert Comment

by:Martin Liss
Comment Utility
Take a look here. I'm going out for a couple of hours and will get back to you about the rest.
ConvertInvalid sheet
0
 

Author Comment

by:Frank Freese
Comment Utility
Wow! Must be these eyes. I did change the name to MainMenu from ConvertInvalid which make more sense. I have learned so much on this project that I'll have a different approach next time. Everyone at EE has been so kind and helpful.
0
 
LVL 45

Expert Comment

by:Martin Liss
Comment Utility
If you mean this list then if you put my code in that hard to find but newly renamed sheet, and you double-click one of the entries then you'll be taken directly to the appropriate sheet.

lstTopic
0
 

Author Comment

by:Frank Freese
Comment Utility
Martin,
Merry Christmas! You "da man"!
Fantastic and many thanks.
Being Christmas eve I'll follow-up with simplfying my user forms that you suggested. The smaller the file the better.
I've deleted a lot I won't need going forward but there's a lot left to do.
I'll also be posting a problem that I have with the Search routine on the "Menu" tab and the error I keep getting when I locate a protected worksheet as a separate question also.
Wife needs "kitchen" help and this is my last time to be nice and not naughty.
0
 

Author Closing Comment

by:Frank Freese
Comment Utility
Great job!
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now