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:
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!
Question
Shadrack
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