Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-01-2020, 11:22 PM
Guessed's Avatar
Guessed Guessed is offline Link UserForm checkbox to corresponding shape on one worksheet and copy to 'template' worksheet Windows 10 Link UserForm checkbox to corresponding shape on one worksheet and copy to 'template' worksheet Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,176
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Ahh, so you are doing this out of spite - that is something I can truly appreciate.



I've done this as simply as I can. I decided your listboxes were a waste of space so I turned them into comboboxes and used the initialise macro to populate a second column with the addresses at the same time. This makes it much faster to apply the address to the right shape on the page as we don't need to find the matching entry in the source table. You can hide the second column if it bothers you by setting the column widths. You could also return to the list boxes as the same functionality would work with them too.

Notice what I did with your dummy addresses - you want the full address in a single cell to make life easier. You can add to that list and because it is a table (list object), the range automatically expands to include the new rows.

The option and checkbox controls all have a Tag property - make use of that to specify the text which could differ from the caption.
Attached Files
File Type: xlsm Mailing Label with help2.xlsm (44.6 KB, 14 views)
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #2  
Old 10-01-2020, 11:57 PM
kiwimtnbkr kiwimtnbkr is offline Link UserForm checkbox to corresponding shape on one worksheet and copy to 'template' worksheet Windows 10 Link UserForm checkbox to corresponding shape on one worksheet and copy to 'template' worksheet Office 2016
Advanced Beginner
Link UserForm checkbox to corresponding shape on one worksheet and copy to 'template' worksheet
 
Join Date: Oct 2017
Posts: 69
kiwimtnbkr is on a distinguished road
Default

LOVING your work! And with so very little code to boot!


Is it possible that when the command button is pressed that the UserForm disappears and just leaves the ToFrom open? Resolved when I realised I already had the appropriate piece of code in another userform.


For the time that there won't be a need for a label but there is a need for Marking 1 to be used, is it possible for Marking 1 to be placed where the current four 'labels' are showing?


Is it possible to have each of the three labels with different border outline colours and matching text colours?


And an assumption on my behalf that the 'Labels' worksheet is no longer needed?

Last edited by kiwimtnbkr; 10-02-2020 at 04:02 AM. Reason: resolved one of my questions
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Trying to link a cell from one worksheet to another gambo Excel 1 01-18-2019 10:26 AM
Link UserForm checkbox to corresponding shape on one worksheet and copy to 'template' worksheet How to populate a userform combobox from an excel worksheet jrooney7 Word VBA 14 09-16-2018 08:52 PM
Userform calls other userform, then populate worksheet Lehoi Excel Programming 0 02-03-2016 02:58 PM
link worksheet on shared file hifrank Word 0 06-24-2015 07:29 AM
Link UserForm checkbox to corresponding shape on one worksheet and copy to 'template' worksheet How do you copy a row from one worksheet to another? mars1886 Excel Programming 3 02-11-2014 02:12 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:09 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft