Excel VBA Course
Excel VBA Course - From Beginner to Expert

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.)

View Course

List Box problem


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.




Hello Edward and welcome to the forum.

If you could upload a sample file (with no personal or private data) that would be very helpful. To upload a file, login and go to your post. In the lower left you will see "Edit". CLick this and you will then see at the bottom "Upload Files". Click the button, browse your computer to the file and upload it. 
What you have described sounds like an easy fix; but without a sample file we could be guessing for hours.

Cheers   :-)
WillieD24 (rep: 547) Mar 23, '24 at 4:46 pm
Add to Discussion


Selected Answer

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   :-)




Thank you for selecting myanswer.

Cheers   :-)
WillieD24 (rep: 547) Mar 24, '24 at 12:51 am
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login