MrExcel Publishing
Your One Stop for Excel Tips & Solutions

please point me in ttthe right direction


Posted by tessa gazzard on December 14, 2001 5:11 PM

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


Posted by Jacob on December 14, 2001 6:13 PM

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

Posted by tessa gazzard on December 14, 2001 6:52 PM

thank you that does help a lot thank you again

Posted by tessa gazzard on December 14, 2001 6:53 PM

would i need a user form or input box

thank you that does help a lot thank you again

Posted by Jacob on December 14, 2001 6:55 PM

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