Good morning
I am trying to populate a ComboBox with a list of names that is contained in another, unlinked, workbook called Busstops.xlsm in a range named "Stopnames" can some one please help.
![]()
Option Explicit Private Sub ComboBox1_Click() ' Select option and place value into the selected cell Selection = ComboBox1.Value Unload Form_Select_Stop End Sub Private Sub UserForm_Initialize() 'Fill the listbox With ComboBox1 .AddItem "hello" .AddItem "Bye" .AddItem "three" .AddItem "three" .AddItem "three" .AddItem "three" .AddItem "three" .AddItem "three" .AddItem "three" .AddItem "three" .AddItem "three" .AddItem "three" .AddItem "three" .AddItem "three" .AddItem "three" .AddItem "three" .AddItem "three" .AddItem "three" .AddItem "three" End With End Sub











LinkBack URL
About LinkBacks
Register To Reply
Bookmarks