I have a workbook that goes and does a match in a different workbook based on entered cell info. I then want to grab the cell contents and somehow display them in the first workbook, perhaps in a textbox. I don't have a userform setup, and I'd rather not if I don't have to. I tried running a macro and copying and pasting the cell contents into a drawn textbox(See Below) but I can't figure out how to do it with code.
ActiveSheet.Shapes("Text Box 1").Select
Selection.Characters.Text = "123456"
I know that I can't use ActiveSheet.Shapes("Text Box 1").print, because it throws up an error that this object doesn't support that function.
What's the easiest way to create a list like this? I'm going to drop between 10 and 20 values into it, and if possible, I'd like it to only appear when I ask for it.
Thanks!!
Steve-O
ActiveSheet.Shapes("Text Box 1").Select
Selection.Characters.Text = "123456"
I know that I can't use ActiveSheet.Shapes("Text Box 1").print, because it throws up an error that this object doesn't support that function.
What's the easiest way to create a list like this? I'm going to drop between 10 and 20 values into it, and if possible, I'd like it to only appear when I ask for it.
Thanks!!
Steve-O