Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #20  
Old 10-06-2020, 05:18 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

The glitch was put in there on purpose because I was sick of having to fill in two addresses while testing. Look in the code to where the Initialise is filling the list. There are two trailing lines that set the ListIndex value to 0 or 1. These lines are telling the control to select the first or second item in the list respectively. You can disable those two lines to leave them blank (Note that the macro fails if you haven't made a selection for both addresses before clicking the bottom button).

Disable the lines by adding a single quote at the start (or just delete them).
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
 

Thread Tools
Display Modes


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 05:15 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