Re: Jak zliczyc ComboBoxy na formularzu

Article View: pl.comp.lang.vbasic

Article #104672

Back to pl.comp.lang.vbasic Previous Next

#104672

From: Gumis
Date: Sun, 27 Jun 2010 23:17

16 lines
1351 bytes

> Mam iles tam formularzy stworzonych pod VBA pod Excelem. Na tych
> formularzach sa rozne ilosci i nazwy ComboBoxow. Jak powinna wygladac 
> instrukcja zliczajaca ilosc takich obiektow na pojedynczym formularzu, a 
> pozniej juz w forze wyciagajaca nazwy poszczegolnych?
>
> Dzieki
> Pozdr

Dim ctl As Control

For Each ctl In Me.Controls
    If TypeOf ctl Is ComboBox Then
        Debug.Print ctl.Name
    End If
Next ctl

Technical Details

Message-ID: <i08m6i$a4k$1@inews.gazeta.pl>

Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.gazeta.pl!not-for-mail

References: <i05icl$v1b$1@news.task.gda.pl>

Show Full Headers

Complete Article Headers

Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.gazeta.pl!not-for-mail
From: "Gumis" <mis_qumis@gazeta.pl>
Newsgroups: pl.comp.lang.vbasic
Subject: Re: Jak zliczyc ComboBoxy na formularzu
Date: Mon, 28 Jun 2010 01:17:36 +0200
Organization: "Portal Gazeta.pl -> http://www.gazeta.pl"
Lines: 18
Message-ID: <i08m6i$a4k$1@inews.gazeta.pl>
References: <i05icl$v1b$1@news.task.gda.pl>
NNTP-Posting-Host: 77-255-149-216.adsl.inetia.pl
X-Trace: inews.gazeta.pl 1277680658 10388 77.255.149.216 (27 Jun 2010 23:17:38 GMT)
X-Complaints-To: usenet@agora.pl
NNTP-Posting-Date: Sun, 27 Jun 2010 23:17:38 +0000 (UTC)
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5931
X-Priority: 3
X-RFC2646: Format=Flowed; Response
X-Newsreader: Microsoft Outlook Express 6.00.2900.5931
X-User: mis_qumis
X-MSMail-Priority: Normal
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit

Reply to Parent Message