Re: Excel i VBA - reguła poprawności - Article 92247 - go-pugleaf

Article View: pl.comp.lang.vbasic

Article #92247

Back to pl.comp.lang.vbasic Previous Next

Re: Excel i VBA - reguła poprawności

#92247

From: Stanislaw
Date: Thu, 20 Oct 2005 21:09

11 lines
1360 bytes

Private Sub Worksheet_Change(ByVal Target As Range)

If Range("B11").Value > 100 Then
    MsgBox "Wartość większa od 100!!!" & vbNewLine & _
           "- wynosi: " & Range("B11").Value, vbInformation
End If

End Sub

--
Stanislaw

Technical Details

Message-ID: <1129842571.418098.120440@o13g2000cwo.googlegroups.com>

Path:

mbox-mo1.pugleaf.net!number1.nntp.dca.giganews.com!border1.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!o13g2000cwo.googlegroups.com!not-for-mail

References: <dj7p0t$b8q$1@news.onet.pl> <4b2f.00000036.4357fd50@newsgate.onet.pl>

Show Full Headers

Complete Article Headers

Path: mbox-mo1.pugleaf.net!number1.nntp.dca.giganews.com!border1.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!o13g2000cwo.googlegroups.com!not-for-mail
From: "Stanislaw" <stanislaw_@op.pl>
Newsgroups: pl.comp.lang.vbasic
Subject: Re: Excel i VBA - reguła poprawności
Date: 20 Oct 2005 14:09:31 -0700
Organization: http://groups.google.com
Lines: 12
Message-ID: <1129842571.418098.120440@o13g2000cwo.googlegroups.com>
References: <dj7p0t$b8q$1@news.onet.pl> <4b2f.00000036.4357fd50@newsgate.onet.pl>
NNTP-Posting-Host: 83.175.176.33
Mime-Version: 1.0
X-Trace: posting.google.com 1129842576 19115 127.0.0.1 (20 Oct 2005 21:09:36 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 20 Oct 2005 21:09:36 +0000 (UTC)
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: o13g2000cwo.googlegroups.com; posting-host=83.175.176.33; posting-account=q9SwWg0AAACsZGpqQVbocTuYdhIZQRhD
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Reply to Parent Message