copy range when I select a value in a combobox

Originally Posted by JBeaucaire

Maybe this:

Range("C1").End(xlDown).Offset(0, 2).Value = Sheets("Sheet1").Range("S14").Value

...but that will probably only work after the sheet has at least one row of data. Are you trying to put a value in column E to match the last entry in column C? If so, maybe this:

Range("C" & Cells(Rows.Count, 1).Row).End(xlUp).Offset(0, 2).Value = Sheets("Sheet1").Range("S14").Value

Yes, I'm trying to put a value in column E to match the last entry in column C (or B). I added this code:

Please Login or Register  to view this content.

in module 1, sub test () but it doesn't work:

Please Login or Register  to view this content.

I don't understand why !?

Originally Posted by JBeaucaire

Me either. It works perfectly on my sheet. Here's a variation on it:

Please Login or Register  to view this content.

You know, check down the C column make sure there's not some value further down the sheet interfering with where you THINK the value should be appearing. Is that line causing an error?

No, it doesn't work . I don't have any error for that line.
column C is empty, except C1 that is the header row.

Originally Posted by JBeaucaire

I repeat, it works perfectly on my sheet. We know it's not working on yours, but we can't see yours, so all we can do is test the line of code.

If you want to post your active sheet, maybe we can see what's causing the problem.

But, I already had attached my workbook in my first post from this thread
If you want I can attach it again!

Originally Posted by JBeaucaire

OK, I examined your sub test() and watched it actually put the value in column E then take it out again later. Not sure which piece of code is doing that, so simply put this version of the code as the LAST line in your macro so nothing else comes after it and it won't get erased:

Please Login or Register  to view this content.

Not working how I need it to work!

This is how I need the macro to work:
By selecting one cell (with blue text) + one value from the combobox, in worksheet "sheet2" :
-the selected value in column A will be deleted
- the selected value in column B will be added
- in column C I will see the adress of the active cell (cell with blue text)
- in column D I will see the blue text from the active cell
I need in column E to copy the range S14 from "sheet1" when I select a value in the combobox !

Please try to select values from the combobox more than one time. If I select only one value in the combobox, the code is working Ok, but if I select another value in the combobox the result is not what I need.
I know that if I use only the code provided by you (without the other line of code) everything is ok. But I need all the code to work toghether.
This is how it looks sheet2 if I select more than one value in the combobox:

Please Login or Register  to view this content.

I need sheet2 to be something like this:

Please Login or Register  to view this content.

I forgot to say thanks for all your effort!

Is not mandatory to use the code from the attached workbook, you can give me an alternative for that code
I don't care what code I use, I just need it to work.

I really need to make this work. Can anyone help me ?

Originally Posted by JBeaucaire

Sorry, I gave up trying to figure your code out. Hope someone else has better luck than I did.

Thank you for your time.

I added some comments in module1 from the attached file (to explain better what this code do):

Please Login or Register  to view this content.

I need in column E to copy the range S14 from "sheet1" when I select a value in the combobox !
The range S14 will have different values!

Is not possible to do this ?

I am still trying to make this work without success.

after all this time, I still try to make this work without success
I would appreciate any help!