copy cell after clicking combobox

[davidausten]

Ive got a Combobox that gets its entries from a dynamic range called selections. What I am missing is that I want to copy the cell over in the next column to the clipboard. Ive tried several things but havent gotten anything to work. Ive tried

Select Case Choose
       Case me.combobox1.value = "test"
            worlsheets(sheet1.select.range("e3").copy)
       end case
end select

Like I said all I want is to copy the cell then I take the contents to another program to paste the value.

 

[BobUmlas]

Select Case True
Case me.combobox1.value = "test"
sheet1.range("e3").copy
end case
end select

 

[davidausten]

thanks BobU tried inserting your code and compiling but get an error on end case

Private Sub ComboBox1_Change()
With ComboBox1

Select Case True

Case Me.ComboBox1.Value = "test"

Sheet1.Range("e3").Copy

End case

End Select

End With

End Sub

 

[davidausten]

heres what i got to compile but it doesnt copy anything because if i try to paste in another cell it pastes nothing.. tried to post the entire workbook but i guess i dont have permission or not enough posts.

Private Sub ComboBox1_Change()
With ComboBox1

Select Case Decide

Case Me.ComboBox1.Value = "Flat Payment"

Sheet1.Range("I2").Copy



End Select

End With

End Sub