ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Just another listbox question . . . (https://www.excelbanter.com/excel-programming/362254-just-another-listbox-question.html)

Jennifer

Just another listbox question . . .
 
Now that Tom has my listbox filling (Thank you by the way) correctly of
coarse i have more questions.

I have a userform w/1 listbox (multi select) that is filled by a combo box.
The user selects a grower and any data that matches the growers id (from the
"Database" worksheet) then is filled in the listbox. What i need now is 3
things:

As the user selects multiple rows in the listbox and hits an enter button
1. the text "Paid" is placed in column "g" for all matching selections on
the database worksheet
2. next all selections are pasted to a worksheet ("GwrStmnts") in a named
range called ("anchor") this is a page that will be printed and sent out to
the growers.
3. is there a maximum number of selections a user can select? such as 20
since only so much will fit in the print area.

Wow, thank you so much!

--
Though daily learning, I LOVE EXCEL!
Jennifer


All times are GMT +1. The time now is 03:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com