add list user form, list box and get input

Hello,

I desperately need help in excel vba. I wrote a macro which creates desired output based on one default variables. But I want to change it to take user selected assumptions and perform the macro for each user selected variables.

I am confused with user forms and controls and what to use.

Can anyone give the code to how to add a list box to a userform and then add items to the listbox, and run macro based on thegiven input in the list box??

Thanks.

Start here
http://www.contextures.com/xlUserForm01.html

Why do you need code to add the controls?

So you have added the controls manually?

Attach an example workbook

Hi rajaneeshjandhyam
The attached workbook contains a demo on how to do what your asking. It's from http://www.lacher.com
and is a free download.

Hi rajaneeshjandhyam
You could fill the list box with an initialize event with code; there's many examples of this on the web. Just do a search on "initialize listbox vba". As far as this

how to get the input from the user into the code

here is an example that I wrote just yesterday

Please Login or Register  to view this content.

If you need further explanation, let me know.
John

jaslake,

Thanks for your guidance. Now I have a little understanding how forms and listboxes work. i was able to add a list box and call it with a button click from a sheet. it shows on the form i created and the values I initialized in the list box. I changed the property to select multiple items. how can i read multiple items selected into a macro that is located in a module?

Thanks for you help so far and in advance. thanks to other guys too who have been helping.

Hi rajaneeshjandhyam
When one uses a single select listbox, you just refer to the listbox value as I previously posted. I've never created a multi-select list box so would need to research that on the web. I did a quick look by searching "multi-select listbox vba" and there's a bunch of stuff there. There are plenty of people on this site that can help you with that issue; I'd need to learn it before I could help.
If you get stuck and can't find answers, let me know. I'm into learning.
John

Hi rajaneeshjandhyam
I'd be interested in learning about multi-select list-boxes myself. Do you have a link to that code? Are there other issues I can help you with?
John

jaslake,

this is the code i used;

Please Login or Register  to view this content.

link: http://www.ozgrid.com/VBA/multi-select-listbox.htm

im having issues with sheet names. i am trying to get sheetnames from a work based on a condition. here is the code:

Please Login or Register  to view this content.

I guess I cant subtract strings. any suggestions?

Hi rajaneeshjandhyam
Thanks for the code. Regarding this

I guess I cant subtract strings. any suggestions?

You can subtract strings if you convert them to integers with "VAL". I have no idea if this will work with what you're trying to do.
Keep me posted on your success. John