Activate command button if data on userform is changed

Question

Afternoon all

I have a Useform which shows data from a worksheet. I have a Command Button "Update", but I would only like it to be usable if the displayed data is changed.

Any Ideas?

Thanks

Steve

Answer 1

Set the Enabled property of the command button to False in the design window.

Create an AfterUpdate event procedure for each of the controls that display data from the worksheet. For example:

Private Sub TextBox1_AfterUpdate()
    Me.cmdUpdate.Enabled = True
End Sub

where cmdUpdate is the name of the command button.

---

Regards, Hans Vogelaar (http://www.eileenslounge.com)

Answer 2

Perfect, Thanks Hans

Steve