where's the tag - with attachment

Hey everyone.

I am hvaing problem in excel... I have a list of applications and checkboxes associated with them so the table looks something like this:
(see picture 1)

The checkbox (not from Control Toolbox but from the Forms pallete) is used to select which applications will be shown on a graph. There are around 90 applications and I want to allow users to add others. Due to complex calculations and interdependencies on other sheets, adding cannot be done by the user inserting a line, but must be done in code instead. All is working fine except I have only one problem:
When I insert a row to the above table, new checkbox is not added and the checkboxes do not move with the application.
Situation after inserting a line:
(see picture 2)

I can move and arrange the checkboxes in the code but I need to associate each checkbox with either application ID or the row number. And for that I need some kind of a property like the "Tag" property in the classic VB. Or is there any more clever solution (index, etc.)?
Thanx in advance.

Cheers,
Brandon.

PS: One more question... how do I insert local picture using IMG tag? (e.g. file d:\pics\picture.jpg)

How are you creating the check boxes? manually or via code?
Have you considered that this should be in a db of some sort (access/mysql?)


Vince

Hi,

so glad to see your name :)
The checkboxes were created by hand but let's consider they are created by the code, as this is the way it will be.

As for the db question - sure, I know and I am the db guy, but this is not my decision and it must be in excel - client's requirement :rolleyes: , you know.

Cheers,
Brandon.

So you have some code to fill in the rows correctly, so you just need to create check boxes via code with ids/names linking to the ids/rows that they reside on.

I haven't done that before, but you might want to record a macro for creating the checkboxes on the row.

Alternatively use a specific value in the last column to say if that row has been selected.

Weird how some places dont want dbs either in vb/access/mysql or whatever. Seem scared of them and want only spreadsheets/text files :D This place I am working for here has shown me that spreadsheet pivot tables are fast n useful for small things, but cannot cope like a db :)


Vince