Excel Forms

[forrestgump]

Hi,

I am trying to create an excel form and I need to get the form text boxes to look at the information of the current rows. I need to reference the cell so I can view the cell on my form and amend and save if necessary. At present I cannot find a simple example to work from.

Can anyone provide a simple example of how a text box links to a cell on a worksheet, can be amended, then saved, and then how the additional cells in the row can be linked to the relevant cells (I think this will be some sort of offset formula).

Any help would be much appreciated.

 

[VoG]

This may be a start http://www.contextures.com/xlUserForm01.html

 

[forrestgump]

Hi,

Thanks for this I have tried this website but it only helps with adding new data not viewing data already there and having the ability to amend the code.

 

[VoG]

Try like this

Private Sub UserForm_Initialize()
Me.ListBox1.RowSource = "A1:A10"
End Sub

You really need to have a more specific question that 'how do I use a Userform".