Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-05-2020, 03:29 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

It looks like you've created additional Marking 1 shapes in your workbook. The workbook I had only had one Marking 1 shape and your screen capture shows 4 of them now. The code I had created to move that one item is going to need to be adapted to deal with the extra 3 instances.



There can be a point where the coding of alternate layouts for multiple conditions becomes so complicated that it can be good to step back and consider alternatives. One such alternative is different worksheets for each layout option and your code starts by hiding sheets and only showing the preferred worksheet and then changes a little text or that 'active' sheet. I'm not sure you are at that point yet but it is worth considering if you intend to keep moving the goalposts as it opens up the layout options considerably.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #2  
Old 10-05-2020, 04:17 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

I did make comment in one of my earlier posts about the need for 4 instances of Marking 1 if no label was selected - lesson learnt for me to add pictures instead of a poorly worded explanation
Quote:
Yes - the labels are mutually exclusive. Nine times out of ten, there will always be one of the labels used. That tenth time, there won't be a need for a label but there will be a need for Marking 1 to be used and to be situated where the 'current' four 'label 1' are showing. Otherwise Marking 1 will sit underneath whatever the selected 'Label' is and as seen in the bottom part of the ToFrom worksheet.
This is one reason I like this forum - you guys that work with this stuff all the time can always see a better way of doing things that us mere 'users and tinkers' can't!

I like your idea of a second worksheet to cover that tenth time were there is no need for any Labels but there is a need for the four instances of Marking 1 and I am creating that worksheet now.

I'm going to hazard a guess that somewhere in the Userform code there will need to be code added to say that if there isn't a label selected but Markings 1 and 2 are, along with the addresses, then to use and display the second worksheet?

Thank you for your perseverance with this... I wish my brain was wired to understand the in's and out's of VBA - I have these bright ideas but not the knowledge to be able to execute them

Last edited by kiwimtnbkr; 10-05-2020 at 04:27 PM. Reason: grammar - lack there of!
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 03:45 AM.


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