Text Box Change Script
 

Hi,
I'm completely new to Visual Basic and surprised myself by creating an
interactive thing for a major company as a contractor -- hey, I told
them up front that I had never done that kind of thing before, but they
hired me anyway -- go figure... One of the things I would have liked
to have done in this interactive workbook was to create a text box on a
user form so that the comment they entered into the textbox would then
go into a preformatted cell in the printed report. The user forms were
a piece of cake, as was the manipulation of resulting data. I just
couldn't figure out how to make the text box work. Can someone help
me, please?
Thanks,
Joy

Text Box Change Script
 

Range("a1")=textbox1.value?

" wrote:

Hi,
I'm completely new to Visual Basic and surprised myself by creating an
interactive thing for a major company as a contractor -- hey, I told
them up front that I had never done that kind of thing before, but they
hired me anyway -- go figure... One of the things I would have liked
to have done in this interactive workbook was to create a text box on a
user form so that the comment they entered into the textbox would then
go into a preformatted cell in the printed report. The user forms were
a piece of cake, as was the manipulation of resulting data. I just
couldn't figure out how to make the text box work. Can someone help
me, please?
Thanks,
Joy

Text Box Change Script
 

Holy &S%$!!! it works! Thanks a bundle... I knew it had to be
something outrageously simple.

Joy


Toppers wrote:
Range("a1")=textbox1.value?

" wrote:

Hi,
I'm completely new to Visual Basic and surprised myself by creating an
interactive thing for a major company as a contractor -- hey, I told
them up front that I had never done that kind of thing before, but they
hired me anyway -- go figure... One of the things I would have liked
to have done in this interactive workbook was to create a text box on a
user form so that the comment they entered into the textbox would then
go into a preformatted cell in the printed report. The user forms were
a piece of cake, as was the manipulation of resulting data. I just
couldn't figure out how to make the text box work. Can someone help
me, please?
Thanks,
Joy