Coding Help Required

[syed_mushraf]

Dear Sirs,

I am new i VB coding plz help me.

I want to store any copied text(Ctrl+C) in a variable and whenever I press Ctrl+V it should be paste from the variable.

What coding should I use get the result.

Thankx in advance.
Rgds,
Musharraf

 

[Richie(UK)]

Hi Musharraf ,

I think I must be missing the point of your post - isn't the 'variable' that you describe exactly the function that the clipboard performs?

Would you provide a little more detail?

 

[syed_mushraf]

Dear Richi,
Actually I have the following set of coding that is change the color when cell pointer moves.

Problem is that when I copy a cell it does not stored on the clipboard. thats why when I paste it any other location it does not works.

I want to define any variable with this coding and when I press copy or Ctrl+C the text should be stored in this variable.

I want to define another function in my coding that will help me when I will press Paste or Ctrl+V.


Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Excel.Range)
Static oldrange As Range
On Error Resume Next
Target.Interior.ColorIndex = 6
oldrange.Interior.ColorIndex = xlcolorindexname
Set oldrange = Target

End Sub

 

[Andrew Poulsom]

Syed,

I thought I had resolved your problem here:

http://216.92.17.166/board/viewtopic.php?topic=27217&forum=2