šŸš€ go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: free.it.visual-basic
Article #3739

Re: VB in Excel (per favore)

#3739
From: Francesco
Date: Sun, 21 Apr 2002 09:26
18 lines
1674 bytes
> >> Funziona perfettamente,grazie 1000
> scusa xkļæ½ con me non funziona?
> che sintassi hai usato?
>
> Allora,se sparo qualche cazzata non mi crocifiggete

Per incollare i dati ho usato questo codice :

Private Sub CommandButton1_Click()
Cells(1).Formula = UserForm1.TextBox1.Text
End Sub

E poi Madcrow" <madcrow74@supereva.it> mi ha consigliato:
Aggiungi questa istruzione dopo quella per incollare il dato
> ActiveCell.Offset(1, 0).Select

Ciao!
Technical Details
Message-ID: <mEvw8.67536$SR5.1715294@twister1.libero.it>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!supernews.com!195.40.4.120.MISMATCH!easynet-quince!easynet.net!feed1.news.be.easynet.net!skynet.be!skynet.be!news.mailgate.org!nntp.infostrada.it!twister1.libero.it.POSTED!not-for-mail
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>

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 02:29:55 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!supernews.com!195.40.4.120.MISMATCH!easynet-quince!easynet.net!feed1.news.be.easynet.net!skynet.be!skynet.be!news.mailgate.org!nntp.infostrada.it!twister1.libero.it.POSTED!not-for-mail
From: "Francesco" <@libero.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: 23
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
Message-ID: <mEvw8.67536$SR5.1715294@twister1.libero.it>
Date: Sun, 21 Apr 2002 11:26:47 +0200
NNTP-Posting-Host: 151.30.73.4
X-Complaints-To: abuse@libero.it
X-Trace: twister1.libero.it 1019381394 151.30.73.4 (Sun, 21 Apr 2002 11:29:54 MET DST)
NNTP-Posting-Date: Sun, 21 Apr 2002 11:29:54 MET DST
Organization: [Infostrada]