userform Max value in Column A

  • Thread starter Thread starter Corey
  • Start date Start date
C

Corey

I am setting up a userform with numerous textboxes.
I want to set 1 of the textboxes to always display the MAX value in Column A
in a particular sheet within the workbook.
How would i code this?

I want it to be in the Userform Activate event.
I have tried something like:


Private Sub UserForm_Activate()
TextBox4.Value = Sheets("Data Sheet for Inspections").MAX(0, x).Value
End Sub

But it no working....


Any idea's


Corey....
 
Hi,

In any cell create the Max function formula then set the text value using
the value of the cell with Max() in it.
 
Private Sub UserForm_Activate()
TextBox4.Value _
= application.max(Sheets("Data Sheet for Inspections").range("a:A"))
End Sub
 
Back
Top