Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy from combobox to worksheet
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy from combobox to worksheet
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Value from ComboBox to Cell | Excel Programming | |||
How can I copy a Combobox with all items ? | Excel Programming | |||
Copy with ComboBox | Excel Programming | |||
Cut/Copy Combobox - I can't update | Excel Programming | |||
Copying Worksheet triggers Click event of combobox on another worksheet | Excel Programming |