Combobox - insert text to cells

Hi,

I have a Combobox which lists text (time-intervals). I managed to split this text in Combobox and put It separately in two cells under, for needs of calculating time differences.

Problem is, that I need this kind of solution for many rows(79) and columns (31), and all this Comboboxes must insert text only in cells right under them. Combobox is not positioned in cell, so I don't know how to write code that would do that, other than write a code for each Combobox alone (that would be like 2.400 times !).

Please take a look at my sample worksheet, notice that only first "solution" (column B and C) is programmed so far. I want It to be done for both (and all afterwards), in a VBA loop maybe...

My code so far:

Please Login or Register  to view this content.

Is It even possible ?

Thanks for help !!

Regards, Luka

Hi Luka,
maybe so

Please Login or Register  to view this content.

Hi nilem,

I tested your solution and It works. But I would prefer visible and docked comboboxes as I have them in my sample worksheet. Do you think that is impossible for all comboboxes ?

I am thinking of just changing this section of your code, so that It would work for all different Comboboxes, but I don't know how to determine their position on sheets :

Please Login or Register  to view this content.

Thanks for response !!

Hi Joakim N,

I agree that nilem solution is nice and I will try to use his code for my needs. As It comes for me his solution would be o.k., but in my case end-user is not happy with It, so I have to change It.

I looked at your solutions, and have to say that I allready did try all this, and that's why I posted a thread on this forum.

In my case only ActiveX controls would be satisfactory, but the problem is that I have like 2400 Comboboxes on sheets, which is quite long code as you imagine.

Form controls are of no use for me, as I need a drop-down list on start/end cells for making own entries, but also to insert a text from Comboboxes - which are commonly used time intervals (shift schedule). So, when you select a new time entry from drop/down list, a formula in start/end cells is being deleted, and then combobox text cannot be inserted again.

But I think could be solved also for my needs, just don't know how yet

Or maybe fixing this code, It loops through all comboboxes but cannot perform command with each one (red colour) :

Please Login or Register  to view this content.

I receive error "method of data member not found" in this code !!

maybe

Please Login or Register  to view this content.

Hi nilem,

that's It, I knew I was very close to solution

I had same code allready, just that I have misstyped comboB as Norie mentioned

But I added some minor things to It, like having It in selection change event of worksheet and to have list in start/end cells where you can enter manually your times If combobox index is 0.

Code :

Please Login or Register  to view this content.

I attached final solution for those who would like to view !

Thanks for all your help !!