My lack of experience is really starting to show. So please excuse my inexperience, however, I have received some help on this in a previous thread.
The code that was send does work, although when I delved into the functions. I came evident that in the spreadsheet I have I needed to produce a uniqueID to re-surface the data and update the information held within different tabs.
So what I have from the code below is a list of UniqueID's based on a criteria, however, I need to be able to produce a similar list, offsetting the returned data from Column "B", to Colum "A" (ie Column1 "UniqueID", Column2 "TaksName")
Sample Code:
The next element is the ComboBox (CB_TaskList), which will have two colums to contain the data from the lists above:Please Login or Register to view this content.
Column 1 = rDict1.keys and Column 2 = rDict2.key
CB_TaskList.ColumnCount = 2
CB_TaskList.ColumnWidths = "40;80"
CB_TaskList.List(1.0)=rDict1.Keys (Fails) or CB_TaskList.Coumn(1)=rDict1.keys (Invalid Property Array Index)
CB_TaskList.List(1,1)=rDict2.Keys (Fails) or CB_TaskList.Coumn(2)=rDict2.keys (Invalid Property Array Index)
Any assistance would be gratefully received
Bookmarks