From cell to combobox

[joey van ginkel]

Dear members,

In the attachment you will find 8 combobox and one input cell (all others are protected), I can navigate through the comboboxes by tab or enter. It will even select the cell, just like I had writen in VBA, but it will not return from the cell into the last combobox.

Does anyone has a solution for this thread?

Kind regards,

Joey van Ginkel
from the Netherlands

[vikas.bhandari]

Why don't you use a textbox rather than a Cell? It will then move the focus as expected.

Let me know if I have understood it incorrectly.

Thanks,
Vikas

[joey van ginkel]

Thanks for your reaction, but when I use a textbox it isn't possible to check of it's a date. Next to that when I create your textbox what would be the code in VBA that you can navigate from this to the next combobox. I already tried but couldn't make it work.

I also know that using a form would be much easier but I know it has to work on this way, but how that's the main issue.

[vikas.bhandari]

Check the attachment.

Sorry for the delay

Thanks,
Vikas

[joey van ginkel]

Sorry for the delayed responding, it looks very nice by tabbing true the file, but could you please try to fill in a date in to the textbox?

You didn't used the best code in VBA.

Thanks Vikas