Selection:bunch of names

**MeisterHim** · 10-08-2005, 04:08 AM

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.

GB · 10-08-2005, 01:05 PM

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