I have programmed a few simple lines:

Private Sub ComboBox1_Change()
ComboBox1.Copy
ActiveSheet.Paste Destination:=Worksheets("RRS-FI tool").Range("G26:G26")
End Sub

The idea is that when I copy the (new) content of the ComboBox, the content
will be pasted in cell G26 of the worksheet. However, not the value of the
ComboBox is pasted, but another ComboBox.

If I look at the Clipboard, it is already a picture, not a value, although
the help text suggests that when copying from a ComboBox, the content value
is copied.

Any way to repair this?

Thanks! Anton

Private Sub ComboBox1_Change()
Range("G26") = Combobox1.Value
End Sub



"antonvanelteren" wrote:

> I have programmed a few simple lines:
>
> Private Sub ComboBox1_Change()
> ComboBox1.Copy
> ActiveSheet.Paste Destination:=Worksheets("RRS-FI tool").Range("G26:G26")
> End Sub
>
> The idea is that when I copy the (new) content of the ComboBox, the content
> will be pasted in cell G26 of the worksheet. However, not the value of the
> ComboBox is pasted, but another ComboBox.
>
> If I look at the Clipboard, it is already a picture, not a value, although
> the help text suggests that when copying from a ComboBox, the content value
> is copied.
>
> Any way to repair this?
>
> Thanks! Anton