My goal is to use VBA code to call out a list box and populate it. The list box would have the characteristic of returning the index to the list item which the user clicked on.
I can't seem to find a list box ready made. Is it a form item? Thus do I have to create a form and then construct
the list box out of some basic elements on the form to do this?
I am not asking anybody to do this or that anyone point to code that exists. I just need help in figuring out how
to think here so that i can do it!!!!! Any advice will be welcomed. Thank you.
This forum is for VB.net not VBA try this link http://social.msdn.microsoft.com/Forums/en-US/vbgeneral/thread/c147bae1-c9db-4ae8-9557-43713004cc94
Coding4fun Be a good forum member mark posts that contain the answers to your questions or those that are helpful
Please format the code in your posts with the button . Makes it easier to read . Or use the Forum Code Formatter by JohnWein http://social.msdn.microsoft.com/Forums/en-US/vbgeneral/thread/bf977a14-d9d4-4e84-9784-bf76b9e23261
ListBox is a basic element we could make use when we start to design a UserForm in VBA, you could insert a UserForm by following steps:
1. Alt+F11 call out the VBE.
2. Click Insert menu.
3. Select User Form.
Then we could draw a ListBox onto the Form through the ToolBox.
For the coding part, please refer to following link:
Please remember to mark the replies as answers if they help and unmark them if they provide no help.