🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: Inserire dati da form in celle Excel

#888
From: Giorgio
Date: Sat, 12 Feb 2005 13:46
66 lines
2426 bytes
1000 Grazie

Saluti

Giorgio

"~Incoming" <speriamo.che.me.l@cavo.it> ha scritto nel messaggio 
news:420d4827$0$32351$5fc30a8@news.tiscali.it...
> Ciao, Giorgio!
> hai scritto Z7vOd.863592$35.32894425@news4.tin.it
> Wed, 09 Feb 2005 21:19:53 GMT:
>
>
> [skip]
>
> > Fin qui tutto bene.
> > Se premo Invio il Setfocus rimane sempre nei 2 campi
>
> tu non premere invio premi TAB
>
> > Il problema sorge che non riesco a trovare il modo per
> > far chiudere il Form
> > di inserimento quando entrambe le celle hanno preso i dati
>
> > Sto utlizzando questo codice
>
> > Private Sub TxtIva_AfterUpdate()
> >   Cells(3, 1) = Me.TxtIva
> > End Sub
>
> > Private Sub TxtNome_AfterUpdate()
> >   Cells(7, 1) = Me.TxtNome
> > End Sub ******************************
>
> > Grazie 1000
> > Giorgio
>
> 'cio che segue e' una rozzzzzzata!!!
> 'megagalattica  :-)
>
> Private Const nVal      As Integer = 2
> Private valInseriti     As Integer
>
>
>
> Private Sub TxtNome_AfterUpdate()
> Cells(7, 1) = Me.TxtNome
> testVal
> End Sub
>
>
> Private Sub TxtIva_AfterUpdate()
> Cells(3, 1) = Me.TxtIva
> testVal
> End Sub
>
> Private Sub testVal()
> valInseriti = valInseriti + 1
>    If valInseriti = nVal Then Unload Me
> End Sub
>
>
>
> Cordialita', ~Incoming.
>
> 
Technical Details
Message-ID: <2NnPd.879320$35.33389551@news4.tin.it>
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!proxad.net!213.200.89.82.MISMATCH!tiscali!newsfeed1.ip.tiscali.net!news-out.tin.it!news-in.tin.it!news4.tin.it.POSTED!not-for-mail
References: <Z7vOd.863592$35.32894425@news4.tin.it> <420d4827$0$32351$5fc30a8@news.tiscali.it>

Show Full Headers
Complete Article Headers
X-Google-Thread: f94ee,da18f1c10e514961
X-Google-Attributes: gidf94ee,public
X-Google-Language: ITALIAN,ASCII-7-bit
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!proxad.net!213.200.89.82.MISMATCH!tiscali!newsfeed1.ip.tiscali.net!news-out.tin.it!news-in.tin.it!news4.tin.it.POSTED!not-for-mail
From: "Giorgio" <internetnostop@aliceposta.it>
Newsgroups: free.it.visual-basic
References: <Z7vOd.863592$35.32894425@news4.tin.it> <420d4827$0$32351$5fc30a8@news.tiscali.it>
Subject: Re: Inserire dati da form in celle Excel
Lines: 68
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Response
Message-ID: <2NnPd.879320$35.33389551@news4.tin.it>
Date: Sat, 12 Feb 2005 13:46:38 GMT
NNTP-Posting-Host: 82.56.32.253
X-Complaints-To: "Please send abuse reports to abuse@tin.it and technical notifications to newsmaster@tin.it"
X-Trace: news4.tin.it 1108215998 82.56.32.253 (Sat, 12 Feb 2005 14:46:38 MET)
NNTP-Posting-Date: Sat, 12 Feb 2005 14:46:38 MET
Organization: TIN