Solved

How to insert Controls at a specific location within the Controls collection when building a dynamic table.

Posted on 2011-02-21
5
462 Views
Last Modified: 2012-05-11
Hi,

I am building a dynamic table which contains multiple rows and each cell contains 7 cells. One of the cells has 2 textboxes. I want to add a label to that cell at runtime. Currently I am only using "add" so it is the last control in. How can I insert the label before the first TextBox?

At present I am doing

cells(6).controls.add(myLabel)

If I want to add it before Textbox2 I do the following

cells(6).controls.Remove(Textbox1)
cells(6).controls.Remove(Textbox2)
cells(6).controls.add(myLabel)
cells(6).controls.Remove(Textbox1)
cells(6).controls.add(TextBox2)

Is there not a better way of inserting a control at a specific location in the collection without removing controls?

Thanks,

Sam
0
Comment
Question by:SamJolly
  • 3
  • 2
5 Comments
 
LVL 52

Expert Comment

by:Carl Tawn
ID: 34942085
There should be an "AddAt" method on the collection that lets you specify the index to insert at:
cells(6).Controls.AddAt(0, myLabel)

Open in new window

0
 

Author Comment

by:SamJolly
ID: 34942184
carl,

thanks for this. So assuming I need to use 2 positions depending on Unit (£ or %) then the following would be correct?

If I had 2 textboxes2

TextBox1
Textbox2

then for "£" I would need :

 cells(6).Controls.AddAt(0, myLabel)

and for "%" I would need:

 cells(6).Controls.AddAt(2, myLabel)

Is my thinking and code correct?

Thanks,

Sam

0
 

Author Comment

by:SamJolly
ID: 34942196
Actually for the "%" I can just do an "Add".

Sam
0
 
LVL 52

Accepted Solution

by:
Carl Tawn earned 500 total points
ID: 34942204
Yes, you only really need to use AddAt() if you want to force a specific location. Add() will add to the end anyway.
0
 

Author Closing Comment

by:SamJolly
ID: 34942484
thanks, very helpful
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

837 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