Userforms automation

shuttlecock

New Member
Joined
May 24, 2021
Messages
1
Office Version
  1. 365
Platform
  1. Windows
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
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.
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
 
Upvote 0

Forum statistics

Threads
1,223,228
Messages
6,170,875
Members
452,363
Latest member
merico17

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top