View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
אלי אלי is offline
external usenet poster
 
Posts: 67
Default Editing multiline textbox

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