Problem with Listbox and Combobox

Many thanks for getting back to me. The defined name range error would certainly explain why this was working and then suddenly stopped. I agree, with this now corrected and a silly combobox reference error correction this now works. It has however highlighted another irritating flaw. The combobox now appears to pick up the adjacent cell values!! This is new and not seen before. Any thoughts on how this can be fixed?

I have attached the revised file.

Your help is much appreciated.


Steve

Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

Thanks Kyle for the feedback. Your comments make sense and I will bear this in mind for the future. I should emphasise at this point that wasting individuals time was not my objective but to simply maximise access to the wider VBA community. I can of course now see the issue with this and will amend my original post accordingly.


Steve

Hi Humdingaling
The combobox is meant to simply display the entries that are found in the first column of the list box. This seems to work initially but after 1 or 2 tries, it starts to display the dates in the adjacement cells. For now I expect it to simply show person 1-2-3. In time as more people take leave, the box will accommodate this by showing person 1-2-3-4-5-6.....
I originally had the list box containing a fixed list of staff members but ran in to trouble when the listbox didn't contain some of those names because they hadn't booked any leave yet. Having the combobox update itself depending on what was in the listbox seemed like the right solution.

Many thanks
Steve

I have resolved my issue. the error highlighted above a simple typo were causing the trouble. Thanks Humdingaling - I am not sure I woud have found that error.