value of a cell into a text box

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

before helping with this i suggest you take a look at my previous post http://www.excelforum.com/showthread.php?t=649878

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, 10:32 AM

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

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

**twofootgiant** · 07-15-2008, 10: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, 12:57 PM

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

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

sorry i didnt mean to say formulas lol.

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

I think this is what you want

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

value of a cell into a text box

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

value of a cell into a text box

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions