I have an issue which i can't solve.I wrote this code:
This code copy a checkbox from (sheet 2) to (sheet 3) starting from V7 cell. Now I want the next time I press the command button to paste the data to cell V12,next time to V17 etc. My vba knowledge is not very good as you can see.
Please Login or Register to view this content.
Last edited by und3raxi; 10-07-2015 at 04:05 AM.
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.
Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be
Click the * Add Reputation button in the lower left hand corner of this post to say thanks.
Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.
Maybe this.
Please Login or Register to view this content.
The above code work perfect but for one time only.It adds only 1 checkbox but ok...Thanks
Okay, where in this that you posted does it say how many times you want it to run?Originally Posted by und3raxi
This code copy a checkbox from (sheet 2) to (sheet 3) starting from V7 cell. Now I want the next time I press the command button to paste the data to cell V12,next time to V17 etc. My vba knowledge is not very good as you can see.
start in row 7
every next time 5 rows +
cel EZ1 in use for counter
Kind regardsPlease Login or Register to view this content.
Leo
Okay, I get it now.
Try this:
Please Login or Register to view this content.
Last edited by skywriter; 10-12-2015 at 06:53 PM.
Both codes work perfect. Thanks a lot both of you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks