Need VBA code to ask users question on opening of shared workbook

[graduate106]

Hi i'm after some VBA code please. We have a shared workbook at work which 10-15 of us all use to keep track of where we are on various jobs in the office.

Ideally what i would like is for the user to be asked a question upon opening of the workbook along the lines of "How busy are you at the moment?" With an option of 1 to 5 (1 being very quiet, 5 being ultra busy), and their answers being copied into a workload tab.

Then at any point the management team can go in to the workload tab and see who is busy and who is quiet so they can reallocate work accordingly.

Is this possible to achieve?

Thanks in advance

 

[graduate106]

At present i can only see how to do this with userforms which are a bit out of my league! Can this be done easier without a userform?