Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding items to a spreadsheet from a user form listbox
Hi: Can someone please tell me how to do the following?: I have a spreadsheet that contains a command button that shows a UserForm. The UserForm contains a ListBox. How do I add items from the ListBox to the spreadsheet? I want to be able to select an item from the ListBox, hit an "Add Item" command button and have the selected item be added to the spreadsheet. The ListBox contains a 6 column database that will be used to insert the selected items into a matching 6 column spreadsheet. Is this possible? Thank you for your help! ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding items to a spreadsheet from a user form listbox
In your AddItem commandbutton_click event just add:
'change to your needs sheet1.cells(5,5) = userform1.listbox1.value sheet1.cells(5,6) = userform1.listbox2.value specifying the sheet will ensure correct worksheet placement. Cells(5,5) is E5. HTH "aet-inc" wrote in message ... Hi: Can someone please tell me how to do the following?: I have a spreadsheet that contains a command button that shows a UserForm. The UserForm contains a ListBox. How do I add items from the ListBox to the spreadsheet? I want to be able to select an item from the ListBox, hit an "Add Item" command button and have the selected item be added to the spreadsheet. The ListBox contains a 6 column database that will be used to insert the selected items into a matching 6 column spreadsheet. Is this possible? Thank you for your help! ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding items to a combo box on a user form | Excel Discussion (Misc queries) | |||
Adding items to columns in a listbox | Excel Discussion (Misc queries) | |||
User form with a listbox | Excel Programming | |||
Transfer multiple columns items form listbox to range | Excel Programming | |||
adding a listbox to a spreadsheet | Excel Programming |