🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: Inserire dati da form in celle Excel

#887
From: ~Incoming
Date: Sat, 12 Feb 2005 00:04
56 lines
2090 bytes
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: <420d4827$0$32351$5fc30a8@news.tiscali.it>
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!proxad.net!213.200.89.82.MISMATCH!tiscali!newsfeed1.ip.tiscali.net!draco.tiscalinet.it!news-f1.tiscali.it!not-for-mail
References: <Z7vOd.863592$35.32894425@news4.tin.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!draco.tiscalinet.it!news-f1.tiscali.it!not-for-mail
From: "~Incoming" <speriamo.che.me.l@cavo.it>
Newsgroups: free.it.visual-basic
References: <Z7vOd.863592$35.32894425@news4.tin.it>
Subject: Re: Inserire dati da form in celle Excel
Date: Sat, 12 Feb 2005 01:04:53 +0100
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
FL-Build: Fidolook 2002 (SL) 6.0.2800.86 - 14/6/2003 22:16:25
X-RFC2646: Format=Flowed; Original
X-Comment-To: Giorgio
Lines: 58
Message-ID: <420d4827$0$32351$5fc30a8@news.tiscali.it>
Organization: Tiscali SpA
NNTP-Posting-Host: 62.11.118.132
X-Trace: 1108166696 news.tiscali.it 32351 62.11.118.132:2729
X-Complaints-To: abuse@tiscali.it