![]() |
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