Hello,
I'm trying to make harmony between the two codes below
The following code enters the value from the combobox directly into cell D32:
...and as for this code, if a value is entered in column D it detects through the range if there is a duplicate of that value and then displays a message box and clears the target cell (in this case it's cell D32). I hope that since cell D32 is linked to Combobox1 then ComboBox1 would automatically clear as wellPlease Login or Register to view this content.
Thanks in advancePlease Login or Register to view this content.
Bookmarks