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:
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:
I need sheet2 to be something like this:
Bookmarks