Hello...
Please help.
I need a VBA code for copying a cell by double clicking it.
I have list of items in a sheet. The item list is on column A. I need to be able to double click any cell on that column A, then it will be automatically copied to
another sheet on column A. The thing is that I need to copy several cells randomly. So the first one I double click will be copied to A2, the second cell I double click will be copied to A3 and so on.
I don't know how to create VBA code that will copy to the next empty cell on column A.
Thank you.
Please help.
I need a VBA code for copying a cell by double clicking it.
I have list of items in a sheet. The item list is on column A. I need to be able to double click any cell on that column A, then it will be automatically copied to
another sheet on column A. The thing is that I need to copy several cells randomly. So the first one I double click will be copied to A2, the second cell I double click will be copied to A3 and so on.
I don't know how to create VBA code that will copy to the next empty cell on column A.
Thank you.