Hi Tom and thanks for your support.

Has soon as put the text between the quotes, the text it self goes to the
next line and the text become red with one quote at the end, and
«Sheet9.Range("A7").Value = ""» stay the same.

There is no error message, nothing to tell you what wrong.

I hope that this would give you a hint.

Again thanks

Cheers

Ren

"Tom Ogilvy" wrote:

What happens when you exceed 990. Do you get an error? What is the error -
please be more descriptive.

--
Regards,
Tom Ogilvy


"Ren" wrote in message
...
Thanks Sharad

I got this LABEL, that when you click on it drops a text in a cells that I
merged.

Something like this:

Private Sub Label17_Click()
Sheet9.Range("A7").Value = ""
End Sub

When I try to put the text between the quotes, the maximum number of
characters that it lets me is 990.

Any suggestions????

Again thanks

Cheers

Ren

"Sharad Naik" wrote:

2,147,483,647

Sharad

"Ren" wrote in message
...
Happy New Year to All

I was wondering if anyone would be able to tell me what is the maximum
number of characters one could place in a textbox.

Thanks for your help.

Cheers

Ren