Member Avatar for CORKINSCS

I WOULD LIKE TO MAKE A NUMBER CREATED, WHEN USING COMMAND BUTTON, TO TRANSFER NUMBER FROM ONE CELL INTO THE ONE SELECTED. FOR EXAMPLE BELOW.

Private Sub CommandButton1_Click()

Range("D2 SHEET4").Value = Range("c21")

End Sub

IS THE EXAMPLE OF WHAT I AM TRYING TO ACCOMPLISH. I WOULD LIKE THE INFORMATION IN C21 ON THE SHEET I AM CREATING THE COMMAND BUTTON ON TO PUT THAT INFORMATION INTO CELL D2 ON SHEET 4 OR CALLED "EXPENSES".

I KNOW ITS PROBABLY VERY SIMPLE, BUT I AM TRYING TO ACTIVELY MAKE THIS SHEET MORE INTELLIGENT.

  • 2 Contributors
  • 1 Reply
  • 188 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by Nutster
Member Avatar for Nutster

Look at the Sheets collection to find the Sheet object for the page.
Worksheets("Expenses").Range("D2").Value = ActiveSheet.Range("C21").Value
This is untested, so might need some tweaking.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.