Set TextBox To Take Array Value

[Juan4412]

I have a text box on my form, that you enter an employee name into then press a button and the button displays a messagebox showing if the employee is Active or In-Active. I want to set it so that I can enter multiple employee names instead of having to do each employee individually. W/O showing the query that runs to pull the status, this is what the Click() Event for my button does

MsgBox tb123 & strStatus, vbInformation

What do I need to alter so that more than one result can be performed and displayed?

[orange]

How do you want to automate it?

If you had employee name and status in a table, you could place the info onto a form in a text box.
You could create a series of msgboxes, but how do you expect these to be seen/used?

[Juan4412]

I was wanting to be able to input an array into the TextBox, then was going to either 1) format the message box so only one employee name was displayed per line OR add in a much larger textbox lower on the form and have the results displayed there.

[rpeare]

you have to have a consistent way of entering the names and a universal separator (space or comma likely won't work)

so let's say you choose the semi colon ;

if you want them to enter their search names

Smith; Jones; Mayberry

You can use the SPLIT function to break this into an array

dim nameArray as array

namearray = split(searchstring, ";")

for i = 1 to ubound(namearray)
    debug.print namearray(i)
next i

then you'd have to jam your search mechanics into the array looping

EDIT: I think arrays are zero indexed like list boxes and combo boxes so you may have to use for i = 0 to ubound(namearray) and when dealing with an array of strings you might have to use dim namearray() as string