value of a cell into a text box

**twofootgiant** · 07-15-2008, 11:10 AM

before helping with this i suggest you take a look at my previous post http://www.excelforum.com/excel-programming/649878-count-blank-cells-within-a-range-not-including-fully-blank-rows.html

I need to display a cell value in a text box on a user form.

This user form will have a button on it which takes the user to the 1st empty cell within a defined cell range (again not including the completley empty rows)

any idea how to do these?

**royUK** · 07-15-2008, 11:32 AM

Which cell contains the value? You can simply use the UserForm_Initialize event to populate a TextBox

Code:

Private Sub UserForm_Initialize()
Me.TextBox1.Value = Sheet1.Cells(1, 1).Value
End Sub

**twofootgiant** · 07-15-2008, 11:59 AM

ok my sheet is called 'CORRECT FORMAT' and the cell is AO7

so what should the formula be?

sorry, im just useless with formulas.

Thanks

**royUK** · 07-15-2008, 01:57 PM

You aren't using formulas in a userform. Do you mean a VBA userform?

**twofootgiant** · 07-16-2008, 04:42 AM

sorry i didnt mean to say formulas lol.

**royUK** · 07-16-2008, 05:44 AM

I think this is what you want

Code:

Private Sub UserForm_Initialize()
Me.TextBox1.Value = Sheet("CORRECT FORMAT").Range("AO7").Value
End Sub

**twofootgiant** · 07-16-2008, 06:04 AM

THANKS... ur a legend !

Thread: value of a cell into a text box