![]() |
|
![]() |
|
Thread Tools | Display Modes |
|
#1
|
||||
|
||||
![]()
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.
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
#2
|
|||
|
|||
![]()
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 |
![]() |
|
![]() |
||||
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 |
![]() |
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 |
![]() |
mars1886 | Excel Programming | 3 | 02-11-2014 02:12 PM |