Excel VBA - Userform Texbox/Scrollbar problem

[thesteelmaker]

I have a texbox that gets its value, on "Initialize", from a scrollbar.

txtNumber = scrNumber

My problem is that i want the value of "scrNumber", on "Initialize", t
be the same as the Max value of column D.

Many thank

 

[Frank Kabel]

Hi
try
scrNumber = application.worksheetfunction.max(activesheet.range("D"))

 

[thesteelmaker]

Thank you very muc