Solved

Adding multiple Labels in a Form

Posted on 2008-10-23
5
244 Views
Last Modified: 2010-04-21
im trying to create multiple labels in a form like we create multiple forms with a form how can i do that?
0
Comment
Question by:BILAL69
5 Comments
 
LVL 5

Expert Comment

by:viju2008
ID: 22789432
can u be more clear with ur question


DO U WANT MULTIPLE LABELS  IN A FORM

THEN ITS AVAILABLE IN THE TOOLBOX  , DRAG AND DROP IT  as many as u want

OR DO U WANT MULITPLE LABELS   AS A CONTROL ARRAY
0
 
LVL 2

Author Comment

by:BILAL69
ID: 22789627
yes i want it like i click the button and it generates a new label automatic
0
 
LVL 4

Expert Comment

by:zstapic
ID: 22790650
Hm... this is not so easy question...

So you might have two different approaches... first, if the number of labels is finite (known) than you can create them and hide them by default. When you click on your button, it should execute a method which will recognize first hidden label and show it :-)

The bigger problem is if you have INFINITE number of labels to add. Than you'll have to use a container, which will be used to possible scroll down to the last label, and also you'll have to create an instances of label class dynamically...

If I can help you with anything else, just ask :-)
0
 
LVL 2

Accepted Solution

by:
Adel87 earned 500 total points
ID: 22793484
Hi,
The following code should do the trick

since you are adding a label then you wont need to access it later on. but if you want to add a remove button also then you would need to add the Labels you are creating to an array to access it later on.

if you need further assistance please let me know.

Regards,
Private Sub Command1_Click()
 

    Dim c As Control

    ' Create and add the new control.

    Set c = Controls.Add("VB.Label", "Text1" & (Controls.Count + 1))

    ' Change the location of the label on the form

    c.Top = (500 * Controls.Count)

    ' Make the new control visible.

    c.Visible = True

    ' Set the initial caption.

    c.Caption = "Hello" & (Controls.Count + 1)
 

    ' Retrieve the text from the new Label.

    MsgBox (c.Caption)
 

End Sub

Open in new window

0
 
LVL 2

Author Closing Comment

by:BILAL69
ID: 31509337
thnx alot
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

896 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now