is it possible to keep an input box open?

[xlBunny]

Hi,

is it possible to keep an input box open?

I would like to just open the input box once and enter the names.
And the input box would just filldown the column with the names as I key them in and hit enter before starting the next entry. Is that something an input box can do?

If it is could you show me how or share a link with me please and thank you

[stnkynts]

try creating/using a UserForm. Seach google on how to design one if you are unsure and submit it here with your requirements for coding.

[xlBunny]

Well once I make the form I still dont know what the code would look like.

[xlBunny]

What I mean is how would it be done some kind of loop. I dont know maybe do until?

[stnkynts]

Submit the file with your userform and a detailed description on what you are trying to accomplish relevent to that userform.

[xlBunny]

Yeah thanks, but no thanks. That seems like a lot of trouble for something so simple. I never did a do loop before or an input box guess I had to just try. With all do respect I dont know why your telling me it couldnt be done and to do a userform.