Userform Interface For Holiday Planner

May 29, 2008

I have one workbook with two worksheets (Jan-JUly and Aug-Dec). I am using a userform to add data into worksheet ("Jan-July"). But I do not have any clue - How do I update the other worksheet (same data like name,join year etc)worksheet("Aug-Dec") at the same time. I used two worksheets because worksheet doesn't support 370 columns, and to make my life easy. UserForm add data into Column A to M (worksheets Jan-July), rest is done manually. I have also attached the file.

Private Sub dataAddButton_Click()
Dim dataCheck, eMsg As String
Dim strLastRow As Integer
Dim x As Double
strLastRow = xlLastRow("Jan-July")
'get Last Row
With dataInput
'dataInput name of userform
If (.fNameBox.Value <> vbNullString And .fNameBox.Value <> vbNullString And .joinYearBox.Value <> vbNullString) Then
'textbox validation value can not be empty......................

View 2 Replies


ADVERTISEMENT

Userform As A Standalone Vb Main Interface

Oct 17, 2006

In order to beutify my prog's interface, i would like to open the Excel file(active VBA) with the worksheet in the minimized background or hide, i.e. only the Userform or a Dialog window, from the right beginning on! as if it was a standalone VB main interface.

View 3 Replies View Related

Userform As Printer Interface For Protected Workbook

Apr 21, 2014

I'm closing in on the final stage of a large project and I've run into a road block. The following line of code is preventing my users from being able to select specific page ranges when using the Print Entire Workbook option in the print menu.

[Code] .....

I've attached the latest version of my form (with significant support by jaslake) to explain what I'm attempting here. The attached form has several macros that activate upon open; including a user form. The password for the workbook/worksheets/VBE is "j".

Attached File : HCT-RCS ITP V1.89.xlsm

View 14 Replies View Related

Work With Main Interface While Userform Is Open

Jul 18, 2007

I'm writing a program on VBA for Excel and I've succeeded in just displaying the Userform when opening the file. I have set the ActiveWindow.Visible option to False and the Application.Visible one to false as well so that i only have the user form displayed.

However, if i try to open an excel file via "My Computer", the file doesn't open. I also noticed that when I was leaving the application.visible option to True, i couldn't access the application while the userform was running. I think i need to do something with an event, but i can't find the event corresponding to opening a file oustide Excel.

View 2 Replies View Related

Protect And Unprotect All Sheets And Workbook Using Userform Interface And Password

Jul 6, 2012

I am trying to create a way to protect and unprotect all sheets and the worbook by means of a Userform pop up interface.

I have managed to create the Userform but what the code will look like and where to place the VBA code that will make it work, Also i would like to automatically save the sheet/s as i switch between them. so that any updates made to the sheet will be automatically saved when i move to the next sheet and also when i protect or close the workbook.

View 3 Replies View Related

Year Planner Mod

Aug 13, 2009

I have a copy of a year planner that calculates the days of the month and adjusts them according to the year input into the header area.

Would anyone please modify it so that the first column reads August and the last column reads July (instead of Jan to Dec) and still maintain the calculations as required?

View 14 Replies View Related

Manpower Resource Planner

Jan 21, 2008

In the past the Manpower Company has put out a yearly spreadsheet allowing an employer to keep track of employee time off. They are not making one this year. Looking at last years sheet, all the calculations are locked. Has anyone seen this sheet in the past and know how it works? You can put in something like v8 in a dated cell and excel subtracts 8 hours from a yearly vacation total. The v in front of the 8 stands for vacation and you can also put in a p for personal time etc..

View 9 Replies View Related

Annual Leave / Vacancy Planner

Apr 8, 2012

I have 7 teams (82 staff in total) staff who work for several production line. we currently record all leave on the wall calender. I want start recording these on a spreadsheet and I wonder if any of you have already designed a annual leave planner that I could have a copy?

Staff can request for 1/2 annual leave as we all full day. Each Team is listed on a seperate sheet and if a team has more than 2 person on leave, it will go red.

View 3 Replies View Related

Recreate Monthly Meal Planner Template?

Jul 31, 2013

I love the set up of the "Monthly Meal Planner" template in Excel 2013 and would like to do something similar for another file I want to set up. How do I learn how to make those tabs across the top - "Meal Plan", "Ingredients" etc?

View 3 Replies View Related

Yearly Planner With Only Mondays Dates Displayed

Apr 7, 2009

I wish to have a simple planner displaying the academic year with only mondays' dates.

ROW 3 displays the dates
Column B is Week 1
Cell B3 is the first date (10.08.09)
Cell C3 should read 17.08.09
Cell D3 should read 24.08.09
ETC

I have managed to do it using autofill before but I can't get it to do it now. Is there a preferred way to achieve this?

View 5 Replies View Related

SAP Interface

Feb 19, 2008

I often need to retrive info from SAP and fill in an excel document with it. Is there a book or a web page where I can find macros that will help me do that?

View 9 Replies View Related

Leave Planner & Box In Colum A To Reduce The Number Of Days

Mar 18, 2009

I was created an annual leave planner and I would like the box in Colum A to reduce the number of days they have left every time they book leave. I would like it to start off as 25 days leave including UK bank holidays.

View 4 Replies View Related

Weekly Leave Planner Reflecting Monday Dates??

Jan 22, 2010

Is there any weekly leave planner that shows the dates of the mondays in the month? eg in Jan we have 4,11,18,2

View 3 Replies View Related

Interface With Attachmate

Jan 1, 2008

I'm trying to write a macro in Excel to interface with "Attachmate".

My problem is when I do a "CreateObject" I receive error for active x can not create object.

I looked in the Excel Ref Lib for either "Attachmate" or "Extra". and could not find them.

Does any one know for sure if Excel can work with "AttachMate" if so can you provide directions.

I'm using Office 2003 Pro, Windows XP.

As a side note I've read of "AttachMate" can be coded to work with "Excel", but so far not the other way around.

View 9 Replies View Related

User Interface For Calculations

Jun 8, 2007

I am trying to create a user pop-up box that can accomplish the following:

a. Pop up box that requests an input for a particular machine number, type of error and also a particular calculation type (STDEV,Average,etc).

b. The result will be displayed either in a tabular format or if applicable, a chart

I have 10 worksheets where each worksheet is a different mahcine ID. Contained within the worksheets is various data-sets(Data listed by week). I am trying to enable my mangers ability to not have to look through my data or choose a worksheet within my workbook. I would rather have a input screen that would give him a choice.

View 3 Replies View Related

Creating A User Interface For An Excel File

Jun 12, 2008

I have been tasked by the company I work for to come up with a simple to use interface that can be used by someone with little understanding of excel to set the autofilters to certain settings.

So here is what I have:

2 sheets (each with the same number of columns but different data which corresponds to good and no-good)

Each column has an autofilter but only two on each sheet need to be set.

One filter controls valve type (of which there are 10) and the other controls running condition (startup and normal)

Now my employer wants something that is basically idiot proof so that someone can simply open up the excel file, input the valve type and running condition, and be rewarded with only the corresponding data and charts. Now the filters are already in place, the charts already exist and the only thing left is the user interface.

View 14 Replies View Related

Control Device Through GPIB Interface Using Excel VBA?

Jun 21, 2006

is it possible to control a device through GPIB interface using excel VBA?

View 4 Replies View Related

Interface Design: Drop Down List Sources

Jun 4, 2006

I am working on a workbook that contains drop-downs in various cells. The source for these drop downs are several Named Ranges on a tab named 'Drop Downs'.

I am locking the whole spreadsheet down so that people are not messing with the format, etc. (which is the current problem). So I don't allow people to add/delete rows, etc.

I am trying to think of a good interface to allow users to modify the entries in each drop down list (i.e. they may need to add a person to the "Resources" Range which feeds into a drop-down box elsewhere).

So, people should be able to add/delete items. I was thinking I would put a little 'X' next to each entry, such that when pressed - it would delete the corresponding entry. (Using the Assign Macro on a Text Box). However, I have to assign each 'X' a method to call - and I can't pass in an argument - so if I assign them all the same macro name - I won't be able to figure out which one was pushed. And the number of 'X' will be dynamic, so I can't hard code a bunch of functions. I don't really have a good idea for allowing additions yet (other than a button that prompts for the name and then adds it in).

I guess I could just use a Form that allows editing of the data (that would be easy and powerful to do), but I don't really want to do that - I want it to be editable within the excel spreadsheet itself.

View 6 Replies View Related

Nifty Email Generator / User Database Interface?

Apr 27, 2012

I've been trying to modify this code in several ways but I can't figure it out, I'd like to

a) use different sections for the email generation where the email address/surname/forename/location are in my user database

b) have a popup screen appear for the body of the email text, I don't like the idea of my secretary having to go into the code to change the text

c) another popup box requesting an email identifier that will set a 'flag' in the Email Information column to show they've had that email and (this may be ambitious) to record the body of the email text somewhere that I can review so there's a record of what's been sent out

This is the code

Dim oXlWkBk As Excel.Workbook ' Excel Work Book Object
Dim oOLApp As Outlook.Application
Dim oOLMail As MailItem
Dim lRow As Long
Dim olMailItem

[code]....

View 3 Replies View Related

Web Form Interface- Amount Of Lines Affects Speed

Sep 18, 2006

I built a web form interface which I use to adjust orders on a web-based system our company uses.

The code I have looks at a sheet, checks if the line needs adjusted, makes adjustments as needed, and then clicks a box for lines needing ordered.

Here is the code I use:

Sub Adjustorder()
Application.ScreenUpdating = False
Dim ie As Object
t = ThisWorkbook.Sheets("Adjust").Range("C3").Value 'checks for valid orders to adjust
If t = 0 Then MsgBox ("No Skus to add"): Exit Sub
Set ie = CreateObject("InternetExplorer.Application")
With ie

This all works fine, but the amount of lines can be anywhere from 1 to 11,000. The fewer the amount of lines needed to loop through, the faster it does each line. With 11,000 lines it took nearly 1 second per line. With 200 lines it took 2 seconds for all of them.

View 9 Replies View Related

Holiday Pay

Nov 16, 2008

I need a formula to compute holiday pay. I am having problems when there are two holidays during the month and the hire date of the employee is after the first holiday. For instance in November, November 11 and November 26 are holidays. If the employee is hired before November 11, he gets paid for the two holidays. If he is hired after November 11, he only gets the second holiday.

A B C 1 HOLIDAYS 2 HIRE DATE RATE/ 11-Nov-09 3 HOUR 26-Nov-09 4 5 10/15/2009 60.00 6 11/16/2009 60.00 7 11/28/2009 60.00 8

View 9 Replies View Related

Holiday Pay Calculation

Jan 17, 2007

I have a problem with a cell displaying the correct number of days.

We work a 38 hour week and therefore each day is 7.6hrs

I have a start date and current date and calculate the number of days employed. I know that each day employed is worth 24 minutes, so over the year it calculates to 20 days per annum.

as I have not entered all the hours taken off yet, my current holiday entitlement is 767:04 (hh:mm).

when I process this on the calculator it tells me I have nearly 101 days holiday due, but I can not get excel to display XX:XX:XX (DD:HH:MM)

What would like to know is how many days that equates to using the 7.6 hour days

View 9 Replies View Related

Staff Holiday Analysis?

Dec 17, 2012

My boss wants me to take the holiday info from SAGE for 80 employees and create a record on excel. He wants to know what holidays each employee has taken and is due to take throughout the year. As each employee works a different amount of hours and a different shift pattern, SAGE records their holiday entitlement in hours rather than days. I have attached an example of one employees details and if come up with an excel document containing similar information for 80 individuals - all starting on different dates and all having a different amount of holiday entitlement. He wants to be able to look at each employees record for the year and see not only holiday data but sick days too. I don't know where to start with this - I've thought about creating a workbook with 80 pages and create a 12 month calendar for each individual with days off marked on it?

View 4 Replies View Related

Advanced Holiday Calendar

Nov 4, 2007

At my job, employees accrue X hours vacation per 2 weeks worked. This makes it difficult for everyone to plan vacation (IE - will I have enough vacation in January to go on vacation for 2 weeks?) I'm trying to create a calendar in my spare time to help out, but it's turning out to be quite a bigger task than I've ever attempted in excel. Therefore, I'm coming here hoping someone will point me in the right direction.

I found this:
[url]
It does the majority of what I need. However, as it costs money, I'm afraid they've locked down editing of things and I won't be able to add functionality to it. It'd be annoying paying them and then finding out I can't add vacation days earned, as the spreadsheet is locked.

Features I'd like added to the above program:
- Add another checkbox (or similar) to show hours of vacation accrued, as well as an original date and hours to start counting from.
- Highlight days corresponding to what kind of day it is. Weekends = red, holidays = green, vacation = yellow, etc.

What I started with:
[url]
This gives me a calendar with the dates in the right place. I've created macros to identify holidays dates. It's starting to get pretty annoying using conditional formatting on everything to highlight days. Especially since I have to do it for each of the 12 months, as it has a hard-coded month cell in there.

View 9 Replies View Related

UK Bank Holiday Calculator

May 2, 2006

I found a link to a website on one of the forum pages. I had a look in the website and it showed a formula for calculating when Easter falls - I didn't know it could be worked out, but it can!!

I therefore decided to investigate further. I picked up another formula to calculate the first MOnday in May and I have now put together a little spreadsheet that will calculate all bank holidays in the year entered in cell B1. It also takes into account additional bank holidays that exist when Christmas Day and/or Boxing Day fall on a weekend.

View 3 Replies View Related

Holiday Roster Templates

Aug 19, 2007

where I might find some?

View 3 Replies View Related

IF Formula Missing Something: Extra Holiday

Jan 21, 2010

using IF formula [ =IF(SUM(C3),LOOKUP(DATEDIF($C3,NOW(),"y"),(0,3,),(0,3,)),"")] holiday sheet after 5 years service employee get 3 days extra holiday trying to in E3 to add 3 days to holiday entitlement to take from 16 days to 19 days

View 2 Replies View Related

Creating A Staff Holiday Spreadsheet?

Sep 17, 2013

Currently I'm working on functionality in my staff holiday spreadsheet and I've come up with this amazing idea for a calendar overview for month by month.Now the sheets I currently have is summary and jan to dec.

I plan on adding the sheets Jan (Cal) to Dec (Cal) now this is when my idea gets nifty - The calendar view will import the information from the month table and will show it on the calendar.

For example X has 1 holiday in July for the 20th - this will show up on the calendar as "x on holiday", I'm still working with spreadsheets so I'm not sure if excel is powerful enough to do this - but is this actually possible?

View 2 Replies View Related

Holiday Program - Export To Ms Outlook

Oct 10, 2008

i have this holiday program (this is linked to networked excel spreadsheets in the origianl) and what i want to do is create a macro that will create an appointment in microsoft outlook calendar for each date everytime i select the cells and click the button with the persons name in the subject. is this possible?

View 13 Replies View Related

Holiday Calculation In Gantt Chart

Jul 8, 2014

Gantt chart to calculate holidays, it now only calculation weekends only, file can be downloaded from here.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved