Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Choose which cell to paste data
Using VBA, I have copied the contents / comments / color etc.. of a
particular cell (single or merged), and wish to manually select (using mouse pointer) which cell to paste the data. So, I guess the VBA code should pause / stop until a new cell is chosen and confirmed. Is this posible? My code so far is.... Private Sub CommandButton4_Click() ' MOVE data Dim Answer As String Dim MyNote As String MyNote = "Move selected data?" Answer = MsgBox(MyNote, vbQuestion + vbYesNo, "For Confirmation") If Answer = vbNo Then Exit Sub End If Selection.Copy With ActiveCell .Interior.ColorIndex = xlNone .ClearContents .ClearComments .UnMerge End With MsgBox ("Please select new cell, where data will be copied to. ") ????????????? ActiveSheet.Paste End Sub Thanks in advance. Mik |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
drop down data want to choose more than one item for cell | Excel Worksheet Functions | |||
choose a range to copy paste based on data in the cells | Excel Programming | |||
Choose merged cell and sum data | Excel Worksheet Functions | |||
How do I choose a cell colour, without it being tied to the data? | Excel Discussion (Misc queries) | |||
choose a cell anywhere and have filtered data appear there? Is there a way? | Excel Programming |