How do I create a multiple selection list box in Excel with VBA?

M

mateo303

I followed the directions on 2007 help in Excel, but then it said, that I
couldn't link the cells or do anything further without VBA code. Please let
me know how to make this multiple selection list box (Active X) work.
 
R

Rick Rothstein

The reason you can't link to a cell is because it is a multiple selection
ListBox. The problem is the user might select more than one item in the
ListBox... which of those items would you expect Excel to put in a linked
cell (assuming it could do that)? The first item in the list? The first item
the user clicked? All of them concatenated together? Whatever it might have
attempted to do, how would it know it was time to do it (that is, how would
it know the user was done selecting items)? There is no right answer here
(as far as Excel is concerned), so it leaves it up to you to use the VBA
interface to craft your (re)action according to your own needs. As to how to
make it work... that depends on what it is you want it to do. Can you
describe what your ultimate goal is?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I create a multi selection list box with VBA code? 0
How can I get a Shareable URL via VBA code to a OneDrive image? 0
Drop down list control value in vba 2
ASK Field Formatting 1
Need Help with a VBA subroutine 0
VBA help with selecting multiple data ranges 1
VBA word change keys 0
Word VBA - Automatic change content of a cell in table using dropdown list 5

Top