LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 4
Default Problem vertically aligning multiple rows with tickboxes added usingVB.

Hi guys.

I searched for days to find the solution to adding a column of
checkboxes down a table with 500 rows in it - a checkbox at the end of
each row. The good news is that I eentually found that someone had
posted a little VB code that did it nicely. I used some additional
conditional formatting and now each individual row changes colour when
the checkbox is ticked! It's a thing of beauty to a new user!

The trouble is that when you get 100 or so rows down the table the
checkboxes gets incrementally and noticeably out of alignment with the
rows. I guess that a tiny vertical misalignment accumulates. By the
time you get to the 500th checkbox, they have run out the bottom of the
table, and gone well below it, and are completely out of vertical
alignment by about 10 rows!

Does anyone have any idea on how to align the checkboxes correctly to
each cell they are sitting above? Or to put it another way; to each row
they should relate to?

Is there some kind of tweak to the VB code that will make them "snap" to
a cell as the script runs? Is there another completely different
solution to get a checkbox-like cell at the end of every row?

Thanks for any help with this
--
Westie
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
HOW DO I RE-NUMBERED MY NUMBER COLUMN AFTER I ADDED ROWS? CARA Excel Discussion (Misc queries) 1 April 14th 06 06:02 PM
resetting last cell jagdish.eashwar Excel Discussion (Misc queries) 11 March 31st 06 02:06 AM
Count on multiple values with duplicate rows Carla Excel Worksheet Functions 1 November 22nd 05 09:25 PM
Moving Multiple Rows at one time Lynda M Excel Discussion (Misc queries) 2 October 3rd 05 09:27 PM
Insert rows Mr. G. Excel Worksheet Functions 3 March 31st 05 03:49 AM


All times are GMT +1. The time now is 11:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"