Subroutine for change to a value on a worksheet

[craigyg]

Hope this question isn't too vague but here goes:

I am able to write subs based on click and change events for a button. I would like to be able to write the same kind of subs for change to a value or range of values on a worksheet. How can i do this?

Thanks-

Craig

 

[Norie]

Craig

You would use worksheet or workbook events.

To access a worksheet's module, where the code will go, right click it's tab and select View Code.

You should now have 2 dropdowns above a code window.

If you select Worksheet from the left one you should see this.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

End Sub

This is the default event for a worksheet and is triggered when selection on the worksheet changes.

The parameter Target is the range that was changed.

There are various other worksheet events that you'll see listed in the right dropdown.

 

[craigyg]

Userform

Related question: What about if I want to do the same thing as before but I want this subroutine to be inside a userform module? (I would like this change to the worksheet to initiate changes on the userform).

 

[Norie]

craig

Can you give more information?

There are various ways you can have worksheets/userforms interact with each other.