where's the tag - with attachment

[BrandonSk]

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)

[Ecniv]

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

[BrandonSk]

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 , you know.

Cheers,
Brandon.

[Ecniv]

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 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