| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| script to change filename | Excel Programming | |||
| A script to write in missing text | Excel Programming | |||
| A script to write in missing text | Excel Programming | |||
| Script to add hyperlink to Excel cell containing text | Excel Programming | |||
| script detecting the change of active cell | Excel Programming | |||
Linear Mode
