PDA

View Full Version : Solved: Locate max number from column A



tqm1
05-08-2007, 11:29 PM
Dear Experts

I want to locate the Larger (Maximum) Number from column A and then want to display it into userform.textbox.value.

Please review attahced sheet.

mdmackillop
05-09-2007, 12:11 AM
Hi TQM,
This has the look of a homework assignment (http://www.vbaexpress.com/forum/faq.php?faq=psting_faq_item#faq_hom_faq_item).

Paul_Hossler
05-09-2007, 05:33 AM
You can use MAX() to read the column, and put it in the text box



Private Sub CommandButton1_Click()
UserForm1.TextBox1.Text = Application.WorksheetFunction.Max(Columns(1))
End Sub