UserForm Retreval, Amend and Return

Hi Leith / Anyone

Ok, I am now stuck, I have created the document but unable to retrieve the data into the Userform.

The signal IDs will always be the same.

1. How do I get the information into the form once I have selected the Signal ID.
2. If one of the lamp has been changed, I would like to press the “Archive lamp button” and have the newest date move to the old date leaving a space to put the new new date in.
3. Is there anyway to force excel into opening on the Aspect Data Entry page whatever page it has been saved on.
Solved this one, see below

Option Explicit
Sub Auto_Open()
Application.Goto ThisWorkbook.Worksheets("Aspect Data Entry").Range("a1"), _
Scroll:=True
End Sub

Again, any help is appreciated.

Neil