Hi and thanks for looking at my post.

This is my 1st real attempt at putting together VBA coding so its may be wrong.

Ok here goes

I have made a UserForm that lets me populate a sheet based upon the

1. Name
2. Date
3. Vacation Hours

all chosen from ComboBoxes(couldn't quite do it with TextBoxes)

It works fine on each individual sheet from seperate buttons & UserForms.

What I'm looking to do is to do it all with 1 Userform for all the sheets.

The sheets are named after each month so there will be 12

heres a copy of the file I have only put 2 sheets in to hopefully make it easier

Book abc.xls

the VBA code is long so could it be shortened (I said I was New)

I look forward to any help or replies

Cheers

Toonies