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
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
2,147,483,647
Sharad
"Ren" <[email protected]> wrote in message
news:[email protected]...
> 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
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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>
What happens when you exceed 990. Do you get an error? What is the error -
please be more descriptive.
--
Regards,
Tom Ogilvy
"Ren" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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
> >
> >
> >
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" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
> > > news:[email protected]...
> > > > 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
> > >
> > >
> > >
>
>
>
It think you would just need to break it into pieces. This is apparently a
limitation of the editor in the VBE.
To demo from the immediate window:
sStr = "abcd" & _
"efgh" & _
"ijkl" & _
"mnop" & _
"qrstuvwxyz"
? sStr
abcdefghijklmnopqrstuvwxyz
Also, I don't really know what the line limit in the editor is, so that may
not be the case. If you have double quotes embedded in your string, those
could be causeing the problem. For example if I had a string
abcdef"ghijk
and I put it between "" it would cause a problem
double quotes in string must be double quoted
"abcdef""ghijk"
for example.
--
Regards,
Tom Ogilvy
"Ren" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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" <[email protected]> wrote in message
> > > > news:[email protected]...
> > > > > 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
> > > >
> > > >
> > > >
> >
> >
> >
Thanks Tom I'll give it a shot and let you know what happen.
Ren
"Tom Ogilvy" wrote:
> It think you would just need to break it into pieces. This is apparently a
> limitation of the editor in the VBE.
>
> To demo from the immediate window:
>
> sStr = "abcd" & _
> "efgh" & _
> "ijkl" & _
> "mnop" & _
> "qrstuvwxyz"
> ? sStr
> abcdefghijklmnopqrstuvwxyz
>
> Also, I don't really know what the line limit in the editor is, so that may
> not be the case. If you have double quotes embedded in your string, those
> could be causeing the problem. For example if I had a string
>
> abcdef"ghijk
>
> and I put it between "" it would cause a problem
>
> double quotes in string must be double quoted
>
> "abcdef""ghijk"
>
> for example.
>
> --
> Regards,
> Tom Ogilvy
>
>
>
> "Ren" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
> > > news:[email protected]...
> > > > 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" <[email protected]> wrote in message
> > > > > news:[email protected]...
> > > > > > 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
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
>
>
>
Hi Tom
The same thing happened.
I seperated the paragraph in three parts, the first two no problem, but the
third went red just like before. When I removed the right amount of text then
it works fine.
Ren
"Ren" wrote:
> Thanks Tom I'll give it a shot and let you know what happen.
>
> Ren
>
> "Tom Ogilvy" wrote:
>
> > It think you would just need to break it into pieces. This is apparently a
> > limitation of the editor in the VBE.
> >
> > To demo from the immediate window:
> >
> > sStr = "abcd" & _
> > "efgh" & _
> > "ijkl" & _
> > "mnop" & _
> > "qrstuvwxyz"
> > ? sStr
> > abcdefghijklmnopqrstuvwxyz
> >
> > Also, I don't really know what the line limit in the editor is, so that may
> > not be the case. If you have double quotes embedded in your string, those
> > could be causeing the problem. For example if I had a string
> >
> > abcdef"ghijk
> >
> > and I put it between "" it would cause a problem
> >
> > double quotes in string must be double quoted
> >
> > "abcdef""ghijk"
> >
> > for example.
> >
> > --
> > Regards,
> > Tom Ogilvy
> >
> >
> >
> > "Ren" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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" <[email protected]> wrote in message
> > > > news:[email protected]...
> > > > > 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" <[email protected]> wrote in message
> > > > > > news:[email protected]...
> > > > > > > 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
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > > >
> >
> >
> >
To confirm (I mean for you) what Tom posted,
it seems to be the limitation of the editor.
In Excel 2003 the editor can take max. of 1022 characters in a single line.
And that including number of characters in the variable + number of spaces
+ the "=" sign.
So no wonder with the Sheet9. ....etc = and the quote marks it allows you
only 990 character of the actual string.
As Tom suggested you need to cut the line with & _
Now & _ takes another 4 characters (including a space before '&' ). So
instead of 990 character you assing
only 986 characters in the first line and 1016 character from next line
onward (1022 minus 4 for & _ + 2 for the quote marks)
Sharad
"Tom Ogilvy" <[email protected]> wrote in message
news:[email protected]...
> It think you would just need to break it into pieces. This is apparently
> a
> limitation of the editor in the VBE.
>
> To demo from the immediate window:
>
> sStr = "abcd" & _
> "efgh" & _
> "ijkl" & _
> "mnop" & _
> "qrstuvwxyz"
> ? sStr
> abcdefghijklmnopqrstuvwxyz
>
> Also, I don't really know what the line limit in the editor is, so that
> may
> not be the case. If you have double quotes embedded in your string, those
> could be causeing the problem. For example if I had a string
>
> abcdef"ghijk
>
> and I put it between "" it would cause a problem
>
> double quotes in string must be double quoted
>
> "abcdef""ghijk"
>
> for example.
>
> --
> Regards,
> Tom Ogilvy
>
>
>
> "Ren" <[email protected]> wrote in message
> news:[email protected]...
>> 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" <[email protected]> wrote in message
>> > news:[email protected]...
>> > > 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" <[email protected]> wrote in message
>> > > > news:[email protected]...
>> > > > > 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
>> > > >
>> > > >
>> > > >
>> >
>> >
>> >
>
>
A GREAT SUPER THANKS GUYS!!!
It works
THANK YOU! THANK YOU! THANK YOU!
Cheers
Ren
"Sharad Naik" wrote:
> To confirm (I mean for you) what Tom posted,
> it seems to be the limitation of the editor.
> In Excel 2003 the editor can take max. of 1022 characters in a single line.
> And that including number of characters in the variable + number of spaces
> + the "=" sign.
> So no wonder with the Sheet9. ....etc = and the quote marks it allows you
> only 990 character of the actual string.
>
> As Tom suggested you need to cut the line with & _
> Now & _ takes another 4 characters (including a space before '&' ). So
> instead of 990 character you assing
> only 986 characters in the first line and 1016 character from next line
> onward (1022 minus 4 for & _ + 2 for the quote marks)
>
> Sharad
>
> "Tom Ogilvy" <[email protected]> wrote in message
> news:[email protected]...
> > It think you would just need to break it into pieces. This is apparently
> > a
> > limitation of the editor in the VBE.
> >
> > To demo from the immediate window:
> >
> > sStr = "abcd" & _
> > "efgh" & _
> > "ijkl" & _
> > "mnop" & _
> > "qrstuvwxyz"
> > ? sStr
> > abcdefghijklmnopqrstuvwxyz
> >
> > Also, I don't really know what the line limit in the editor is, so that
> > may
> > not be the case. If you have double quotes embedded in your string, those
> > could be causeing the problem. For example if I had a string
> >
> > abcdef"ghijk
> >
> > and I put it between "" it would cause a problem
> >
> > double quotes in string must be double quoted
> >
> > "abcdef""ghijk"
> >
> > for example.
> >
> > --
> > Regards,
> > Tom Ogilvy
> >
> >
> >
> > "Ren" <[email protected]> wrote in message
> > news:[email protected]...
> >> 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" <[email protected]> wrote in message
> >> > news:[email protected]...
> >> > > 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" <[email protected]> wrote in message
> >> > > > news:[email protected]...
> >> > > > > 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
> >> > > >
> >> > > >
> >> > > >
> >> >
> >> >
> >> >
> >
> >
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks