Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
NickHK, thanks for your reply.
Can you explain how to do it with a Listbox? Eli "NickHK" wrote: Something like: TextBox1.value=TextBox1.value & " juice" But that is the same line Or do you mean: TextBox1.value=TextBox1.value & vbnewline & "juice" So what happens when the user uncheck that CheckBox ? Seems that a ListBox would be more appropriate for your needs. NickHK "???" wrote in message ... Rick, Before one of the checkboxes are checked the textbox has one line, with for example the word - apple. I am asking about the creation of new line inside the textbox that the word apple will appear with the word Juice for example. So the textbox after one checked checkbox will be: apple apple juice apple pie (after the seconed checked checkbox) Eli "Rick Rothstein (MVP - VB)" wrote: I have simple userform with one multiline textbox and 6 checkboxes. My problem is how to make that checking a checkbox will copy the textbox value to a new line without deleting the upper line. I tried various things but I cant avoid the deletion of the upper line (especialy in the case of more then one checked checkbox). Copy the "textbox value" to a new line? Where is this new line going? Did you, perhaps, mean to type "copy the CheckBox Caption property to the bottom of the TextBox? If not, I think you will need to clarify what is being copied and to where. Rick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Textbox and multiline text | Excel Worksheet Functions | |||
Multiline textbox for data entry | Excel Programming | |||
Userform Textbox multiline Vs format in worksheet | Excel Programming | |||
UserForm; Textbox; Multiline; NonPrintable Characters | Excel Programming | |||
Multiline textbox.. Can you have multiple font colors within? | Excel Programming |