Hello,
I have written an UDF that generates several values. I have written a messagebox that give the results in a text string of about 8 lines. When I dimensioned the function as a string, it returned the entire string without formatting into the cell that called the function.
What I would like is for vba to throw a text box onto the worksheet in the vicinity of the cell that called the function. Is this easy to accomplish.
Thanks in advance.
Dale
I have written an UDF that generates several values. I have written a messagebox that give the results in a text string of about 8 lines. When I dimensioned the function as a string, it returned the entire string without formatting into the cell that called the function.
What I would like is for vba to throw a text box onto the worksheet in the vicinity of the cell that called the function. Is this easy to accomplish.
Thanks in advance.
Dale