Userforms automation

[shuttlecock]

Hi,
Hopefully someone on here is able to help, i am not familiar with VBA .
i have a leave spreadsheet with 12 tabs for that calculates staff leave, their name in column B and the date in row 2. This workbook is read only for staff and only editable for managers. what i would ideally like is a form for staff to send to managers and for the managers to approve the leave on the form and the form update the leave planner in the relevant tab and date for the employee that has requested.

Would this be possible in excel using VBA to be an automated process

thanks in advance

 

[dmt32]

Hi,

Welcome to forum.

Excel can be made to do a number of things & with a lot of work, what you are seeking to do but probably is the wrong platform to achieve it.

This is just my personal view but my first thoughts were maybe using Access database application could be better suited to your need & then noted you are using Office 365 which may have PowerApps with built-in templates for you to use.

I would hasten to add it’s not my area of expertise & would suggest talking to your IT people to determine if this feature is available to you.

You can have a look here:How To Setup an Office 365 Holiday and Time Off Request App Using Power Apps | SlashAdmin \ Life in IT

at this site for a suggested solution which may give you something you can build on.


Hope helpful

Dave