populating worksheet column from combobox

Could you upload your workbook? At least provide the full code attached to the combobox.

As for opening the form when the workbook is opened - is "UserForm1" in fact the actual name of the user form?

The code to open the form is correct. Are macros are being enabled when the file is opened?

Your code for the combobox_click event is only writing to one column so I don't see why you are trying to find the last row in columns B & C, unless you have more code to add for writing values into those columns.

Anyway you could use this if you are only writing to the last row in column-A.
Please note I've used sheet code names and you may have to change the sheet reference.

Please Login or Register  to view this content.

To answer your second question, no my userform is employee_daily, however that's what I used.

Then your workbook_open event should read:

Please Login or Register  to view this content.

Palmetto,
I tried your code and still the same result, except that on sheet2 after selecting my first pick, and then just clicking anywhere within the user form, that first pick value ended up in the next row a couple of columns over. Sheet6 didn't respond at all. I don't understand why you can't pick repeat values within a combobox and not have them show up in subsequent rows - doesn't make sense to me.

Thanks
Chris

I tried your code and still the same result, except that on sheet2 after selecting my first pick, and then just clicking anywhere within the user form, that first pick value ended up in the next row a couple of columns over. Sheet6 didn't respond at all.

That could not occur withthe code I gave you.
It would be best if you uploaded your workbook so that we can see all of the code and structure.

I don't understand why you can't pick repeat values within a combobox and not have them show up in subsequent rows - doesn't make sense to me.

You can. See attached.

Palmetto,

That could not occur withthe code I gave you.
It would be best if you uploaded your workbook so that we can see all of the code and structure

.

You're correct, in messing around with the properties, I set the control source for the combobox to f3. As soon as I removed it it stopped doing that

So I tried what you sent, however I still can't successively pick the same name and have it show up in the next row in column header1? I can for instance pick "Shawn" then say pick "Ken O" then "Shawn" again:

Shawn
Ken O
Shawn

but not:

Shawn
Shawn
Shawn

Is this normal?

So I tried what you sent, however I still can't successively pick the same name and have it show up in the next row in column header1? I can for instance pick "Shawn" then say pick "Ken O" then "Shawn" again:

It is working correctly in the workbook uploaded in my last post. Did you try that workbook?

Without seeing your actual workbook or all of the code and however you may have tried to adapt it, it's hard to say where the error is occuring.

It is working correctly in the workbook uploaded in my last post. Did you try that workbook?

Yes, I did upload it, and no it is not working, at least not the way I assume it should - it does the same thing mine does. I even tried removing all the names with the exception of one. I would expect that you could keep selecting that name and it would fill each successive row in that column with that name but it does not?

I would expect that you could keep selecting that name and it would fill each successive row in that column with that name but it does not?

OK. It seems to have finally sunk-in.

Add this line of code at the end of the click event and it will "reset" the list and allow you pick any item as many times as you want.

Please Login or Register  to view this content.

Thankyou Thankyou Thankyou!!!!, I new there had to be something that would allow this to work.

Chris

Glad to have been of help.

If you're satisfied with the solution please mark your thread as solved and remember to add to the reputation of those who contributed.


How to mark your thread solved

How to add to a users reputation