Results 1 to 4 of 4

Thread: where's the tag - with attachment

Threaded View

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Aug 2000
    Posts
    195

    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)
    Attached Files Attached Files
    Brandon

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width