LinkBack URL
About LinkBacks
Hi,
I need to create a lot of Check boxes and ensure they are all the same size and all aligned. Is there an easy way to do this? At the moment I am creating each box and manually aligning it.
Hi,
I need to create a lot of Check boxes and ensure they are all the same size and all aligned. Is there an easy way to do this? At the moment I am creating each box and manually aligning it.
Hi,
This link may help?
http://articles.techrepublic.com.com...1-1041101.html
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
This site has a neat code to create check boxes, select a range of cells. then run the macro and checkboxes will be created in the selected range,
http://blog.livedoor.jp/andrewe/archives/17357484.html
Good afternoon pauldaddyadams
Create a checkbox, and set it to the size you want. Now copy it, by left clicking and dragging and then press and hold Ctrl till you let go. This will create and identical checkbox.
To align them up, hold down Alt while you move them, this will "snap" the border of the checkbox to the nearest cell border, making them easy to line up. This also works to resize them to the size of a cell.
Finally, once you have a checkbox selected, you can use the arrow keys for fine tuned miniscule movements.
HTH
DominicB
Please familiarise yourself with the rules before posting. You can find them here.
Thanks for all the help and the quick responses.
With this help I have now managed to achieve what I set out to do.
The post from davesexcel was very good – this will prove very valuable!! I just used the code and it worked a treat.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
,
Bookmarks