Linking the value to another worksheet

kidmann · Jan 1st 2021

Hi guys,

I'm pretty new to VBA literally and couldn't determine how to link the value to another worksheet in excel.

Here is my code:

Code

Sub Tshirts()
Range("c5").Value = Range("c5").Value + 1
End Sub
Sub Tshirts_less()
Range("c5").Value = Range("c5").Value - 1
End Sub

Display More

royUK · Jan 1st 2021

Welcome to the Forum. Please read the Forum Rules to understand how the Forum works and why I have added Code Tags to your post

All VBA code posted in the forum must be wrapped in code tags, which you omitted, including single-line code snippets.Be sure to use them in future posts.

How to use code tags

Note: no apostrophe in the tags, just used for demonstration here.

['code]

your code goes between these tags

['/code]

Or, just highlight all of the code and press the <> in the post menu above button to add the code tags.

Thanks.

royUK · Jan 1st 2021

You need to explicitly state the sheets being used. This is one way

Code

Sub Tshirts()
Worksheets("Sheet name here").Range("c5").Value = Worksheets("OtherSheet name here").Range("c5").Value + 1
End Sub

Share