I'm trying to use a listbox in excel userform as of it was a column in the sheet and put multiple lines of text.
Is there a way to do this, or is there another active x control that I can use? I saw the excel active x control, but it will not work out. I need to be able to enter text in it like in a colmn.
It will be used to later run a loop and step one by one text in the control.
I know I could use text box place one under the other, but, I would not be able then to paste text in it taken from an excel sheet.
Any idea on how to bypass this or make it work would be nice.