how to use user form to create a list box with separate return

**VYES** · 07-25-2014, 06:49 PM

HI,

I need to make a list box in the user form that allows me to select multiple products and return the average return of each products in a message box separately.
Products are a,b,c AND Their date of return are in different worksheets.

see attached sheet.

thanks

**Bishonen** · 07-25-2014, 08:07 PM

theres no listbox nor a userform in the file you embedded. What should be shown in the listbox? Dates? or just a b c. What are we averaging? All values of a/b/c or all values of a given date.

**VYES** · 07-26-2014, 10:58 AM

Thanks. Just a,b,c in the list box, and average of each value in message box.

**Bishonen** · 07-26-2014, 04:52 PM

s (1).xlsm

Hope this is what you're after

**VYES** · 07-26-2014, 06:10 PM

Thank you!That's awesome!

how to use user form to create a list box with separate return

LinkBack

Thread Tools

Rate This Thread

Display

how to use user form to create a list box with separate return

Re: how to use user form to create a list box with separate return

Re: how to use user form to create a list box with separate return

Re: how to use user form to create a list box with separate return

Re: how to use user form to create a list box with separate return

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] User Form - Hyperlink Button within a Form, to create a Link on a Designated Cell

[SOLVED] User Form to execute search and return all values to the user form for editing

Trying to create a multiple user to do list that generate information to separate sheets

Create a user form with a multi-column list box

Create User form to pull from equipment list and fill in data

Bookmarks

Bookmarks

Posting Permissions