Problem populating a list box
Folks,
The attached workbook uses two list boxes. List box lstTopics is populated by lstCategory. My problem is that in populating lstTopics I populate the list box except for the last item, regardless of the Category selected
Function-and-Formulas-for-Excel-.xlsm
The attached workbook uses two list boxes. List box lstTopics is populated by lstCategory. My problem is that in populating lstTopics I populate the list box except for the last item, regardless of the Category selected
Function-and-Formulas-for-Excel-.xlsm
Martin Liss
I'm working on it.
BTW if you don't mind I'd like to switch from ActiveX listboxes to Forms ones so as to avoid the problem with the listboxes text becoming tiny
ASKER
No problem with the change to Forms
Talk tomorrow
Talk tomorrow
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I like the idea of a blank line in the lstTopics.
In opening the workbook as presented and without resaving it I loose the tabs and the scroll feature on the list box, but I trust they're working fine for you.
One of the properties in the list boxes I had to change was setting the Locked property to True. At False everytime I selected an item from a list box the box shrink until there was no box. This is simply informational.
You've been right on so far and I would close this question and move on. The next question is once a Tpoic has been select then the GoTo select command box is enabled.
After that question consider this as a question. Once the GoTo command button is enabled as a new command button labeled "Change Category or Toice" would be added and enabled. This would allow the user the opportunity if they change their mind based upon the description and wanted to select another Category or Topic.
Following that question we can then have a question that will locate the item selected (=====>) so the user knows where it is they will be going. I planned on making the description more meaningful anyway.
OK to go forward?
The problem I have is what workbook do I post? The one you just sent back and saved under a different name?
In opening the workbook as presented and without resaving it I loose the tabs and the scroll feature on the list box, but I trust they're working fine for you.
One of the properties in the list boxes I had to change was setting the Locked property to True. At False everytime I selected an item from a list box the box shrink until there was no box. This is simply informational.
You've been right on so far and I would close this question and move on. The next question is once a Tpoic has been select then the GoTo select command box is enabled.
After that question consider this as a question. Once the GoTo command button is enabled as a new command button labeled "Change Category or Toice" would be added and enabled. This would allow the user the opportunity if they change their mind based upon the description and wanted to select another Category or Topic.
Following that question we can then have a question that will locate the item selected (=====>) so the user knows where it is they will be going. I planned on making the description more meaningful anyway.
OK to go forward?
The problem I have is what workbook do I post? The one you just sent back and saved under a different name?
In opening the workbook as presented and without resaving it I loose the tabs and the scroll feature on the list box, but I trust they're working fine for you.I don't know what that means, but in any case yes, it's OK to go forward. You should post the workbook I posted (renamed if you like) but I don't plan on downloading it and instead I'll just use mine.
ASKER
Great job
Many thanks
Many thanks
ASKER
Question will be posted shortly