Excel VBA - Userform Texbox/Scrollbar problem
 

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

--
Message posted from http://www.ExcelForum.com

Excel VBA - Userform Texbox/Scrollbar problem
 

Hi
try
scrNumber = application.worksheetfunction.max(activesheet.rang e("D:D"))

--
Regards
Frank Kabel
Frankfurt, Germany

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",
to be the same as the Max value of column D.

Many thanks


---
Message posted from http://www.ExcelForum.com/

Excel VBA - Userform Texbox/Scrollbar problem
 

Thank you very muc

--
Message posted from http://www.ExcelForum.com