VBA to show cell information using a check-box

[Cremorneguy]

Hi there,

I have a spreadsheet full of data and I want to insert a check-box in one column next to all the data. Each row is a single entry spread over a few columns. I have a second sheet which is to be printed with the information from each row.

Is there a way where if I tick a check-box, the information on that row will appear in the printable page.

For example, I have four rows of data filled out. I don't want to print row 1 or 2, but I tick the box for rows 3 and 4. I want these to appear on the printable page, in the same order I have ticked them, row 3 being placed in the first row of the printable page and row 4 being placed in the second row of the printable page.

Is this possible?

[Keebellah]

I would suggest you take a look here to get ideas, the specific code is the next step
http://www.extendoffice.com/document...heckboxes.html

[HaHoBe]

Hi, Cremorneguy,

IŽd get away from the idea of using Checkboxes and use a ListBox (with checkboxes activated) for that. Besides: from which origin, Forms or ActiveX? As many as you have data or reuse one and keep the information in the line?

You could use a simple Lookup/Macth Index to get the information over.

Ciao,
Holger