PDA

View Full Version : Selection not displaying in dropdown box



peacenik
06-06-2007, 04:58 PM
The attached spreadsheet has a Form called "ImportLender". I have some code to populate the dropdown box, (that I copied from something I found here - thank you if you recognise your work) and it works fine but when I select an option from the dropdown list, it doesn't get displayed in the box as usually happens. The macro works, but it is offputting for users when they are not sure if they selected the correct thing.

The macro can be activated from the Menu "BC Accred"

peacenik
06-06-2007, 05:17 PM
Sorry, I suppose it would be good to remove the password from the VBE

peacenik
06-06-2007, 05:22 PM
Hopefully, I got it right this time.