List box population that does not seem to happen

[TimRussell]

I am writing some code to have a date pre selected in a set of 3 list boxes and then when the ok button is pressed this date will be added to the excel spreadsheet instead of the date that was originally in the cell. The problem that occurs is that one of the list boxes seems to poulate with the correct number of entries but they are all blank when checking them with msgbox value.

Below is the user form initialize and select button subs

Please Login or Register  to view this content.

I have tried a number of ways of getting the data into the list boxes - thus the number of comments. It also doesn't make sense that the problem with the values started with the year(listbox7) and then has moved to the month(listbox6) and the day(listbox5) on occasions Also the other date information (listbox 2,3 and 4) are fine

Thanks for your help in advance

[Andy Pope]

pretty hard to tell from that code alone, especially when some of the variables used are not defined.
for example in these line only V is defined, and that's a local variable.

Please Login or Register  to view this content.

Can you post example file?

[Izandol]

May you post a workbook sample?

Are the listboxes multi-select? Are the listboxes that do not work different from the the listboxes - it seems they may sit in a Frame control?

[apo]

Just a quick one.. not the answer to your question.. but..

Change this:

Please Login or Register  to view this content.

to this:

Please Login or Register  to view this content.

[TimRussell]

I seem to be having a problem adding the attachment - here is a link to a google drive file

https://drive.google.com/file/d/0B9P...it?usp=sharing

Hope that works

The problem I am having is is user form 2 list boxes 5,6,7

[Andy Pope]

how do we use it?

I tried running update_audit macro but it fails on overflow variable. (I corrected the error of incorrect workbook name)

[TimRussell]

Each of the 4 buttons will perform a task within the spreadsheet - the one that is proving a problem for me is the update audit - just checked and found that without any data it has an issue - will fix and resend out

[TimRussell]

So take 3

Link for the g drive
https://drive.google.com/file/d/0B9P...it?usp=sharing
and attachment

[Andy Pope]

Sorry I must be being think but what is not working? What do we need to do in order to see the actual problem.

If I select a date from Listbox1 and press Select, items in listbox5/6/7 get selected.

[TimRussell]

What i am trying to do is when I select a audit from list box 1 the day of audit is automatically selected in list boxes 5,6,7 This looks like it is happening with the items selected, the plan is to use the out put of these 3 to repopulate the date of audit cells. However when I try to get this auto selection 1 of the lists does not select and after investigation I had discovered that it would not display the values in a list using the following

Please Login or Register  to view this content.

Which seemed to be the root of my problems - as I was trying to select the item using .listindex or .selected and that produced a "" result

[Izandol]

Perhaps you may use .List(.Listindex) rather than .Value?

[Andy Pope]

When you use the .Selected() array to set the highlighted item you can not use the Value property, even though the Multiselect is set to single.

Please Login or Register  to view this content.

[TimRussell]

Andy / Izandol
So then I would need to use the listindex and array's to provide the values I need to populate the adate (in the ok button procedure) - I'll give that a go and see what happens - thanks for your input

[TimRussell]

So I have just tried and using the following code - works

Please Login or Register  to view this content.

Thanks again for your help