Solved

Adding multiple Labels in a Form

Posted on 2008-10-23
5
245 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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Suggested Solutions

Introduction In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
When designing a form there are several BorderStyles to choose from, all of which can be classified as either 'Fixed' or 'Sizable' and I'd guess that 'Fixed Single' or one of the other fixed types is the most popular choice. I assume it's the most p…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
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…

786 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