• 0

Getting the TEXT out of a Listbox not the index


Question

I'm creating an Excel 5.0 Dialog in Excel 2003. I must say, the interface is poop. I expected at least the same functionality as Access Form designer, but nothing close. There isn't even anything for aligning objects!!!

I guess I could have done an Excel Form, but that didn't seem obvious after I got started. I could probably still port over the code I've written to a form if I have to. Ok.. I?ll stop rambling.

The only method I've found for getting anything from my listbox is:

ActiveDialog.ListBoxes("Recommend_Trade_Name").Value

where Recommend_Trade_Name is the name of the list box I need to get the value from. The problem is, that the value is just returning the index of the selected item, I need the Text of the selected item. The help sucks ass and I'm getting very frustrated and want to call Microsoft and cuss them out.

If anyone can alleviate my grief, I?d appreciate it greatly!

-Nic

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.