Textbox to fill with max formula result

Hello

I try to fill a textbox in a userform with the result of a max formula of a certain sheet, but no result..

What i try is this.

Please Login or Register  to view this content.

Any help on this?

Thank you in advance

Hi Maria,

See the attached where I got it to work. See my code of below and where I've placed it..

Me.TextBox1.Value = WorksheetFunction.Max(Application.ActiveSheet.Range("A1:A50"))


Userform TextBox Max Value Test.xlsm

Thank you Mr Marvin

Certainly works if i open the userform from sheet1.

But if i want to open it from another sheet ?

Please Login or Register  to view this content.

Does not works

Hi Maria,

If you want to get the max from another sheet try something like this:

Please Login or Register  to view this content.

Is this what you wanted? If not then you should supply a sample workbook so we can get a better understanding of the problem.

Add one dot and move one parenthesis

Please Login or Register  to view this content.

Thank both of you.

Apologize for the delay of my respond but i had no conection with the forum until now.

Mr Mike suggestion works great for me.

Regards