Prev: Colour code specific name if it appears in a group of names
Next: Another Sumif problem
From: Chip Pearson on 9 May 2010 19:14
>Why so many lines of code?

Because it makes the logic much easier to understand. One of the
purposes of the newsgroups is, I think, to educate the users rather
than just provide some code that a user can copy/paste without
understanding how it works and what it does.

Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]



On Sun, 9 May 2010 15:56:15 -0400, "Rick Rothstein"
<rick.newsNO.SPAM(a)NO.SPAMverizon.net> wrote:

>Sorry about the following, but it is Sunday and things are kind of slow
>around here.<g>
>
>Why so many lines of code?
>
>Private Sub TextBox1_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger)
> KeyAscii = -KeyAscii * (Len(TextBox1.Text) < 6 And _
> Chr(KeyAscii) Like "#" And KeyAscii <> 8)
>End Sub
From: Rick Rothstein on 9 May 2010 19:41
I think you may have missed my opening sentence and the <g> symbol that
followed it.<bg>

--
Rick (MVP - Excel)



"Chip Pearson" <chip(a)cpearson.com> wrote in message
news:b9geu5t79neug3uaq0qcdhjpgrcr9d9gp0(a)4ax.com...
>>Why so many lines of code?
>
> Because it makes the logic much easier to understand. One of the
> purposes of the newsgroups is, I think, to educate the users rather
> than just provide some code that a user can copy/paste without
> understanding how it works and what it does.
>
> Cordially,
> Chip Pearson
> Microsoft MVP 1998 - 2010
> Pearson Software Consulting, LLC
> www.cpearson.com
> [email on web site]
>
>
>
> On Sun, 9 May 2010 15:56:15 -0400, "Rick Rothstein"
> <rick.newsNO.SPAM(a)NO.SPAMverizon.net> wrote:
>
>>Sorry about the following, but it is Sunday and things are kind of slow
>>around here.<g>
>>
>>Why so many lines of code?
>>
>>Private Sub TextBox1_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger)
>> KeyAscii = -KeyAscii * (Len(TextBox1.Text) < 6 And _
>> Chr(KeyAscii) Like "#" And KeyAscii <> 8)
>>End Sub

First  |  Prev  | 
Pages: 1 2
Prev: Colour code specific name if it appears in a group of names
Next: Another Sumif problem