BrandonSk
Sep 15th, 2004, 03:45 AM
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)
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)