please point me in ttthe right direction

Hi

This should get you started.

Make a Userform

Private Sub Workbook_Open()
userform1.show
End Sub

Then in the userform have a place for the name, date, etc

For age try this
Assume BDay is the name of the birthday field

= Today() - BDay

for day of birth try this

= Text(BDay,"DDDD")

Hope this gets you started.

Jacob

thank you that does help a lot thank you again

would i need a user form or input box

thank you that does help a lot thank you again

Both would work. NT

: i would like a sspreadsheet that would on opening bring up a user form to ask 1) Name 2)date of birth thiss informaation i would like displayed in a empty row from this information i would like to work out 1)how old the person is in years and monthes 2)how old they are in days and three thee day of the week thaat they were born on is this possible if possible i would want a message boxs to displaay this info like you aare so many day old ect i have just staarted studing vba and have the vba programming for dummies but still i kind of stuck any help would be appriciated especially on the message box stuff