I have a bunch of names of which i want to make a selection when i open
the excel document. So for example A1:A20 are names of which i want to
make my own selection of say 8 names. When i open the document a window
pops up in which i can check the 8 names i want to select. Also when i
check more then 8 name it has to give some kind of error after which i
can uncheck one (or more) name(s). Then those 8 names have to be placed
somewhere in the document say B1:B8.
Thanks in advance to then ones that can and do :P help me with this.


--
MeisterHim
------------------------------------------------------------------------
MeisterHim's Profile: http://www.excelforum.com/member.php...o&userid=27401
View this thread: http://www.excelforum.com/showthread...hreadid=474446

Haven't written the code for you, but if you use a form, that populates based
on the data available, and on the form is a multi-select list window. Every
time a name is "picked" it checks to see how many are currently selected, if
it exceeds 8 then, it can "error." A "Save" button could be used also, and
if the user attempts to store less than the lesser of 8 names or the number
of names in the list, than an error is provided. Once the Save button is
selected, each of the names or whatever data associated with the row is
stored where you want it.

Next in line to help with the actual code? :)

"MeisterHim" wrote:


I have a bunch of names of which i want to make a selection when i open
the excel document. So for example A1:A20 are names of which i want to
make my own selection of say 8 names. When i open the document a window
pops up in which i can check the 8 names i want to select. Also when i
check more then 8 name it has to give some kind of error after which i
can uncheck one (or more) name(s). Then those 8 names have to be placed
somewhere in the document say B1:B8.
Thanks in advance to then ones that can and do :P help me with this.


--
MeisterHim
------------------------------------------------------------------------
MeisterHim's Profile: http://www.excelforum.com/member.php...o&userid=27401
View this thread: http://www.excelforum.com/showthread...hreadid=474446

still haven't been able to figure this out. anyone know some actual cod
to solve this problem

--
MeisterHi
-----------------------------------------------------------------------
MeisterHim's Profile: http://www.excelforum.com/member.php...fo&userid=2740
View this thread: http://www.excelforum.com/showthread.php?threadid=47444

nobody knows something to help me?


--
MeisterHim
------------------------------------------------------------------------
MeisterHim's Profile: http://www.excelforum.com/member.php...o&userid=27401
View this thread: http://www.excelforum.com/showthread...hreadid=474446