![]() |
|
|
Thread Tools | Display Modes |
#20
|
||||
|
||||
![]()
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 |
Thread Tools | |
Display Modes | |
|
![]() |
||||
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 |