Problem copying cells contents from one worksheet to another.

Can anyone help me with an excel vba userform issue im having?

I’m trying to copy and paste data in a cell from one worksheet to another, but when I try to paste the data into the second worksheet, it pastes it into the same cell, but on the first worksheet??

Im launching a userform via a macro on the first worksheet, called “Risk Assessment”. This switches over to the second worksheet, called “Hazard Selector”, and loads my userform.

Heres the code for that macro, assigned to a button in the “risk assessment” worksheet.

Please Login or Register  to view this content.

I then use the form to make some selections in the “Hazard Selector” sheet, which put data into cell D11 on the “Hazard Selector” sheet.

Using a button on the userform I then want to copy this D11 data, switch back to the “Risk Assessment” worksheet and close the userform. Im using this code to do this, assigned to a button on the Userform.

Please Login or Register  to view this content.

This seems to work, and I have the contents of cell D11 on my clipboard, however, when I now try and paste this data into my “Risk Assessment” worksheet, for example into cell A1- nothing happens.

Instead, the contents paste into the “Hazard Selector” worksheet instead, into cell A1?!

I cant for the life of me figure out why, can anyone help?!

Many thanks

Mod Edit: You are required to use code tags around your code - I have added them for you. I have also removed all the extraneous line returns in this post to make it legible.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. As you are new here, I will do it for you this time: https://forum.ozgrid.com/forum/index...et-to-another/)

Try:

Please Login or Register  to view this content.

I suspect that, when you copy the cell, you see the "dancing ants" around it. When you click on another cell, they are still there and hence you can right click and paste the data. However, I imagine that some action or event is cancelling the selection … the dancing ants are no longer dancing … and the data is no longer available to paste.

You could, maybe, copy the cell to a variable, do whatever action is clearing the clipboard, and then copy the variable to the clipboard.

Please Login or Register  to view this content.

Courtesy: https://stackoverflow.com/questions/...vba-excel-2013

However, launching my userform from a button on my first page doesnt allow me to paste the data correctly?

I guess. I have nothing to help me diagnose the problem or offer a solution.