listbox transfer to a textbox
Posted on 2007-11-18
1) This code below isnt poulating my listbox 'fault_listbox'. I dont know why?! If fault range is in another worksheet to the current will this effect it?
.MultiSelect = 1
.RowSource = [FAULT_RANGE].Address
2) I want the user to be able to pick mulitple values from the listbox and then hit a command button to display those selected in a textbox. They can be dragged or displayed via a commandbutton but nothing else. The user must not be able to select the same item within the listbox twice.
Could anyone help me to do this please?
p.s i'm after some additional help for a fee to develop code -(too much foe EE)- please let me know or refer me to people who could be interested