LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,824
Default help to speed up adding check box

Maybe this will help. (Adjust the range to what you need)

http://groups.google.com/groups?thre...0A8B%40msn.com

jono1970 wrote:

hello,

I need to place 50 check boxes in column D of my worksheet. Currently
I go to *view*, *toolbox*, *forms* and drag a check box object in to a
cell. I then have to edit, size and place it within the cell. Is there
a way to quickly replicate this in VBA. I would appreciate it if
somebody could show me how to do this.

Thanks in advance.

Jono

--
jono1970
------------------------------------------------------------------------
jono1970's Profile: http://www.excelforum.com/member.php...o&userid=15658
View this thread: http://www.excelforum.com/showthread...hreadid=271931


--

Dave Peterson

 
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
Adding an "X" or Check to a cell by clicking on the mouse KAZ Excel Discussion (Misc queries) 5 May 6th 23 11:44 AM
Increase size of a Forms Check Box (click on to enter check mark) 718Satoshi Excel Discussion (Misc queries) 0 August 17th 07 01:52 AM
Can you speed UP drag speed? Ryan W Excel Discussion (Misc queries) 1 October 24th 05 06:09 PM
Adding Check Boxes Mike R Excel Discussion (Misc queries) 2 February 13th 05 03:59 AM
Adding a check mark to the custom made toolbar/menu continue...... aiyer[_59_] Excel Programming 0 September 2nd 04 12:52 AM


All times are GMT +1. The time now is 07:07 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"