200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Hi I'm new to excel. I have a list box with 20 items, I'm trying to figure out a way
to be able to pick an item and place it on my spread sheet in a certain column. So far
I can get one on the sheet, what i need to do is place several in sequence as i pick them.
Any help appreciated.
Edward233
Hi Edward,
I have used VBA to add the selected items to the "Data Sheet" in C3:C12. Items are selected one at a time. As items are added to the "Data Sheet" the count goes up. If the count reaches 10 a message box pops up to indicate the max has been reached and nothing more happens (nothing more gets added). On the "Signs" sheet I added an information line to let the user know how many items have been picked. I also added an information area to indicate what the currently selected item is. I also added a button to clear the list on the "Data Sheet".
This could also be achieved using a UserForm instead of a ListBox.
The attached file shows the changes have made.
Hope this helps; if so, please mark my answer as Selected.
Cheers :-)
