Thread: Characters
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Characters

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