I apologize for any newb mistakes. I am new to learning excel and real new to VBA code. I was wondering if anyone can help me with a code.
I want to have a Axtive X Command button then when you click the button it copies the text contents from another sheet without switching and highlighting that cell (silent?) i have code for copying to clipboard from the same sheet but it only works well when the command button is on the same sheet on top of the cell. If you move the text it will jump and highlight that cell. Again i apologize if its not clear what i am looking for. Here is the code i have that works for copy to clipboard using the command button.
Private Sub CommandButton1_Click()
Range("F48").Select
Selection.Copy
I want to have a Axtive X Command button then when you click the button it copies the text contents from another sheet without switching and highlighting that cell (silent?) i have code for copying to clipboard from the same sheet but it only works well when the command button is on the same sheet on top of the cell. If you move the text it will jump and highlight that cell. Again i apologize if its not clear what i am looking for. Here is the code i have that works for copy to clipboard using the command button.
Private Sub CommandButton1_Click()
Range("F48").Select
Selection.Copy