Article View: free.it.visual-basic
Article #3740Re: VB in Excel (per favore)
From: Madcrow
Date: Mon, 22 Apr 2002 06:37
Date: Mon, 22 Apr 2002 06:37
30 lines
1955 bytes
1955 bytes
Ho creato uno UserForm con un pulsante di comando e una TextBox. Nella routine click del pulsante ho inserito questo codice: Cells(1).Formula = UserForm1.TextBox1.Text ActiveCell.Offset(1, 0).Select Poi mi sono accorto che dovevo cambiare Cell(1) con ActiveCell altrimenti mi avrebbe scritto sempre sulla stessa. Ciao! -- Per rispondere in privato rimuovere NOSPAM "AccessDenied" <access_deniedTOGLIMI@katamail.com> wrote in message news:3Shw8.65447$SR5.1649213@twister1.libero.it... > il giorno Thu, 18 Apr 2002 13:13:23 +0200, "Francesco" <@libero.it> ha > affermato: > > > >> Funziona perfettamente,grazie 1000 > scusa xkļæ½ con me non funziona? > che sintassi hai usato? > > > -- > AccessDenied > > MySite :accessdenied85.cjb.net > E-Mail :access_denied@katamail.com
Technical Details
Message-ID:
<HcOw8.10977$8D3.308634@news1.tin.it>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!supernews.com!newsfeed.online.be!skynet.be!skynet.be!news.mailgate.org!news-out.tin.it!news-in.tin.it!news1.tin.it.POSTED!not-for-mailReferences:
<aKYu8.46145$m41.1219635@twister2.libero.it> <imav8.22346$b62.629119@news1.tin.it> <fWxv8.52500$SR5.1342699@twister1.libero.it> <3Shw8.65447$SR5.1649213@twister1.libero.it>Show Full Headers
Complete Article Headers
X-Google-Language: ITALIAN,ASCII X-Google-Thread: f94ee,acbd602ae48dee4d X-Google-Attributes: gidf94ee,public X-Google-ArrivalTime: 2002-04-21 23:37:29 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!supernews.com!newsfeed.online.be!skynet.be!skynet.be!news.mailgate.org!news-out.tin.it!news-in.tin.it!news1.tin.it.POSTED!not-for-mail From: "Madcrow" <madcrowNOSPAM74@supereva.it> Newsgroups: free.it.visual-basic References: <aKYu8.46145$m41.1219635@twister2.libero.it> <imav8.22346$b62.629119@news1.tin.it> <fWxv8.52500$SR5.1342699@twister1.libero.it> <3Shw8.65447$SR5.1649213@twister1.libero.it> Subject: Re: VB in Excel (per favore) Lines: 32 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4807.1700 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700 Message-ID: <HcOw8.10977$8D3.308634@news1.tin.it> Date: Mon, 22 Apr 2002 06:37:27 GMT NNTP-Posting-Host: 212.216.43.6 X-Complaints-To: newsmaster@tin.it X-Trace: news1.tin.it 1019457447 212.216.43.6 (Mon, 22 Apr 2002 08:37:27 MET DST) NNTP-Posting-Date: Mon, 22 Apr 2002 08:37:27 MET DST Organization: TIN