Article View: pl.comp.lang.vbasic
Article #92243Re: Excel i VBA - reguła poprawności
From: Stanislaw
Date: Thu, 20 Oct 2005 09:34
Date: Thu, 20 Oct 2005 09:34
11 lines
1441 bytes
1441 bytes
Jeżeli podsumowanie miałbyś w komórce B11,
to w module tego arkusza wstaw kod:
Private Sub Worksheet_Change(ByVal Target As Range)
If Range("B11").Value > 100 Then MsgBox "Wartość większa od 100!!!"
End Sub
--
Stanislaw
Technical Details
Message-ID:
<1129800847.045608.19780@f14g2000cwb.googlegroups.com>Path:
mbox-mo1.pugleaf.net!number1.nntp.dca.giganews.com!border1.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!f14g2000cwb.googlegroups.com!not-for-mailReferences:
<5af6.0000176a.43575d99@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!f14g2000cwb.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 02:34:07 -0700 Organization: http://groups.google.com Lines: 12 Message-ID: <1129800847.045608.19780@f14g2000cwb.googlegroups.com> References: <5af6.0000176a.43575d99@newsgate.onet.pl> NNTP-Posting-Host: 80.50.68.122 Mime-Version: 1.0 X-Trace: posting.google.com 1129800852 25192 127.0.0.1 (20 Oct 2005 09:34:12 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Thu, 20 Oct 2005 09:34:12 +0000 (UTC) In-Reply-To: <5af6.0000176a.43575d99@newsgate.onet.pl> User-Agent: G2/0.2 X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; MyIE2; exNetPanel:292739; SV1; npUID:292739; .NET CLR 1.1.4322),gzip(gfe),gzip(gfe) Complaints-To: groups-abuse@google.com Injection-Info: f14g2000cwb.googlegroups.com; posting-host=80.50.68.122; posting-account=q9SwWg0AAACsZGpqQVbocTuYdhIZQRhD Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit