Call Tracker - VBA Coding: Input Screen To Auto Clear The Fields Once The " Save " Button

Oct 24, 2009

1) We need the Input screen to auto clear the fields once the " Save " button has been pressed and data transfered to the appropriate tracking sheet

2) We want to ensure that if any of the Red cells are empty the " Save " button will give an error ( one complication If the "Transfer Type" highlighted in Blue has an entry " either STD/ISD/ESP " then " Call Purpose " needs to be mandatory

3) somehow the information on the "Comment " field is not getting captured

4) If possible we want a warning indicator if two rows in a tracking sheet ( example London ) are the same based on Coloums B to I ( except C )

5) Is there any possibility to give a pop calender in the " scheduled date " section of Input screen (Row 33)

View 3 Replies


ADVERTISEMENT

VBA - Use Command Button To Obtain Save As Screen And Save As PDF

Jun 22, 2014

I have a UserForm in which i have inserted a CommandButton. I also have a Table on a Sheet in Excel that i would like to save as PDF.

When i click the CommandButton on the UserForm i would like the SaveAs screen to come up and have the Table (or Used Range in the Excel Sheet) as the selection to be Saved as .PDF format.

View 3 Replies View Related

Air Force Mission Tracker-Auto Counting & Auto Copying

Jun 19, 2009

Making a mission tracker that requires less upkeep than my units previous methods. I am using Excel 2007 and have some things in mind that I would like it to do.
On the down side, I have only basic experience with excel and have never used macros or VBA.
Even if what I am after could be solved with functions (which I prefer), I simply do not quite know how to make what I want without assistance. Ok, now on to the description.

The mission tracker aside from showing a list of the missions we have done during our program, it needs to also generate metrics automatically. In my worksheet, I am using columns A-G and rows 1-501.

The mission scheduling type in Column E are listed below. The letters on the left are what I am using in the sheet, the part to the right is what it really means:

Column D has the day of the week listed as: Mon, Tues, Wed, Thurs, Fri, Sat, Sun.

now the metrics I need to be generated are the number of different types of each mission compared, how many of each type of mission was flown per day of the week, how many of each type of mission was flown per month.

Basically what I need is a way to automatically count the number of rows that meet a specific criteria throughout the range. This would require being able to check the value/text of multiple cells at a time and count the number of rows that meet that criteria.

[SOLVED] 1. The first part would be to have the worksheet be able to count the number of each type of the 9 mission scheduling codes throughout the range. I would be storing the count in new cells that would then be connected to pie charts.

[SOLVED] 2. The second part would be to count the number of each type of mission that was flown per day of the week. That would require searching both mission type and day of the week. All I would need is a working formula for 1 set, then I could switch mission codes and weekdays to match all the 63 possible outcomes.

3. Knowing the number of each type of mission flown per month. This would be checking the date and the mission type. The trickier part that comes up in my mind is that our programs span multiple calendar years, so it would have to track it by month and year, that way there is a difference between Jan 2009 and Jan 2010. The counted numbers would be used to make histograms. It would be nice if the chart titles could be automatic based on the dates inputed in the mission tracker. If I needed to choose a maximum time length for it to cover, I would pick 3 years.

4. I would like to figure out how to make an inputted line of data on the main tracker sheet to create a copy in the corresponding worksheets based on schedule type, that way a person could look at/print a specific type without having to sort the main list.

The actual goal is to make it where a person can enter the 1 line of data per mission (cells A-G) and the mission metrics update automatically after each mission is inputed allowing upper level supervision to have current information quickly whenever it is needed. Currently we need about a weeks lead time to get the information asked for on our current progress.

View 10 Replies View Related

Input Data In A Cell And Press Enter - Auto Save?

Dec 28, 2011

I have a excel sheet in it. Is it possible? That when in any cell I input data in a cell and press "enter" then it save automatically.

View 8 Replies View Related

Input Data Then Clear Cell But Save To Another Cell?

Jan 29, 2014

I want to be able to see the average rating for each employee.. Is there a way to put in the rating from one survey and have it automatically add it another cell and then have it clear the first cell?

Here is an example of what I would like to do: Say we get 2 surveys with one rating of 5 and one rating of 10... If I input the 5 into cell Q4 and have it automatically put into cell R4 and then it gets deleted from Q4 but saved to R4... and then I can add the rating of 10 to Q4 and it automatically ads it to R4 and clears Q4 and totals R4 to an average of 7.5.

This way, with each new survey I can just input each rating to Q4 and have it cleared for the next rating and then have an average rating of all the surveys in R4... we do not need to keep track of how many ratings we are getting, just the average rating.

I have attached the excel sheet if you would like to take a look at what I am trying to do..

View 1 Replies View Related

Naming Spreadsheet And Coding A Button

Apr 29, 2009

I have a macro attached on Sample 01 that outputs a couple files after a certain date. The problem is the date that it choses is always "todays" date and I want to be able to change the date, the cell that I need to be able to change is cell c2. The problem is the rest of the formulas in the cells change to number format and don't stay in date format.

how to add code to a button. I think I've more or less solved my own problem with merging the data of two spreadsheets together (not as cleanly as I'd like of coarse), but the problem is the person I'm going to train to use this spreadsheet is not very computer savvy and this needs to be as easy as possible. So I want them to just be able to click 3 buttons and be done with the process.

View 4 Replies View Related

How To Clear Contents Of Clipboard Before Tool Takes Screen Print In Excel VBA

Apr 20, 2014

I've have a tool/code that takes the screen prints of the active window (when I press F9) and pastes it in a word document.

But whenever I do copy some text or any other image and when I press F9 to take the screen print of the active window. I get the text pasted into the word, this is because the clipboard content has text first and then the screen print of the active window.

Instead When I press F9, I wanted the below to happen

1. Content from the Clipboard should be cleared

2. Take the screen print

3. Paste it in the word document.

Note: My tool/code already does 2 and 3. Looking for 1 alone, ,

View 4 Replies View Related

Move Data To List & Clear Entry Fields

Feb 15, 2010

this are function which button needs to be able to do after clicking on it.

When the value of only one of Description or Unit/Price is entered, a warning message appears.

When the message is confirmed, return to the entry status for the new data.

When the values of both Description and Unit/Price are entered, save the values in the list of product (worksheet Product), and increase Product No. by 1 and erase values from NewProduct worksheet this is the screen how it should look but button which should be able to do all the thing above at once is called List Entry
[url]

after creating this function all the values from the table product need to be update into another table which sould look like that:
[url]

Is there anyone how could write code which will do thing above?

in the attachemnt is the excel file which shows what I have done so far, as i am not a good programmer,so I do not know if it's right

View 7 Replies View Related

Show The Find Screen For Search Input

Mar 23, 2007

I am trying to do is create a button that when pressed, will bring up the Find screen (which can be brought up by pushing ctrl + f)...I tried to record it as a macro but nothing came up.

View 9 Replies View Related

UserForm Input (a Button That Opens An Input Box Or Dialog Box)

Jul 4, 2006

I have to design an input user form (a button that opens an input box or dialog box), which asks user to "Enter number of "columns"".

User enters a number i.e. 2 or 3 etc

It then asks user for the headings of these coulmns and places first column heading in A1 and second column heading in B1, third in C1 and so on ...

View 9 Replies View Related

VBA Code For Full Screen With Save As

Aug 21, 2013

i have an excel workbook containing approx 20 worksheets. What I would like to do is make the workbook go full screen when the user opens the file and allow the user to save as into the same file path the workbook is stored when closed

View 2 Replies View Related

Matching Up Fields With Variable Input

Oct 12, 2009

Example:
Order Number from VendorOrder Number from SupplierTracking Number from Supplier12345123451ZABCD13456134561ZBCDE134561ZCDEF14567145671ZDEFG1456714567

In these three orders, the first order nubmer has a 1-to-1 relationship with a single tracking number. In the second, there are two different tracking numbers associated with one number from column A. In the third, there is only one tracking number but three different lines of the same order number that need to be updated with it.

The question is, is there a way to line up data fields head to head even when there are variable inputs like this?

View 15 Replies View Related

Force Auto Full Screen

May 16, 2007

How I can force the application to auto full screen and hide all toolbar?

View 5 Replies View Related

Call Macro If Button Is Clicked

Jan 30, 2009

I need a code for "click-able button" in my excel sheet that will call makro "copy" which I have connected with ThisWorkBook /Sub copy() .../ or in other case with Modules (module 7 for example).

So, what to add between this:

Private Sub CommandButton1_Click()

?

End Sub

View 9 Replies View Related

Call A Command Button In A Macro

Apr 22, 2006

I have created a command button so that the sheet asks for a password. Now I need to include that in an already created code. I have created a command button as:


Private Sub CommandButton1_Click()
If LCase(Me.TextBox2) = "password" Then
Run "Showall"
Else
Run "Hideall"
End If
End Sub

Can someone tell me how to call this macro in another macro. That is when another macro is running and if the condition fails, this macro should be called. Is it something like run "CommandButton1"?

View 9 Replies View Related

Call A Function With A Macro/button

May 23, 2006

I want to call on a function with a macro/button in the same way as when you choose "insert-function" but in a way that the user himself is able to put in values on the spredsheet.

View 7 Replies View Related

Call / Run Commad Button Procedure

Jan 10, 2008

Is it possible to call a Forms Command Button procedure from a Module?

View 3 Replies View Related

Auto-Adjust Workbook To Screen Resolution

Nov 6, 2012

I am using code to auto adjust screen resolution when opening a workbook so that my workbook will span that computer screen of anyone opening it.

How to taylor it specifically for each worksheet as they differ in size in terms of what cells are used??

Code:

Private Sub Workbook_Open()
Dim Vis_Rnge As Range
Dim Data_Rnge As Range
Dim X_Fact As Double
Dim Y_Fact As Double

ActiveWindow.Zoom = 100

[Code] ..........

View 1 Replies View Related

Force Data Input In Specific Fields Before Exit

Mar 22, 2007

I have an excel sheet that has two text fields "A2" 2 digit (Month) and "B2" 2 digit (Day of week), both are currenlty in a text format. I need to force the users of this sheet to enter values in both of these fields prior to saving. Is there a simple macro that I can run to check these fields.

View 8 Replies View Related

Array With Button Names, Call Them One By One In A For Loop

May 12, 2009

I am having a problem calling buttons. I have an array with button names and another array with their caption texts and I would like to call them one by one in a for loop:

For i = 1 To UBound(button_array)
Sheets("Statistic").Shades(button_array(i)).Caption = button_text(i)
Next i

But the only way I seem to be able to call them is by their set names, like:

Sheets("Statistic").statistic.Caption = button_text_ENG(i)

View 2 Replies View Related

How To Call Save As Prompt If Directory Doesn't Exist

Apr 1, 2014

I am using this code to generate a text to a directory, but I would like to know how to call a save as prompt if the directory doesn't exist?

[Code] ..........

If the folder macro does not exist, then it will prompt a message saying that the folder macro cannot be found, and the save as prompt will appear.

View 3 Replies View Related

Auto-Adjust Screen Resolution When Opening A File

Sep 18, 2007

I have made an excel spreadsheet. The area with data exactly fills my screen.

When I send it to other colleagues, it perfectly fills their screen too. But for some colleagues the data area is either too big for their screen or takes up a small proportion of their screen based on their screen resolution. I would like the area with data to perfectly fill the screen of all people who will access the file.

I am thinking that I would do an automatic event so that I can change the settings upon opening the file. I have Excel VBA programming for Dummies which explains about automatic events but I have no idea what sort of sub procedure to use.

View 2 Replies View Related

Command Button - Create A Save Button In Sheet 1?

Mar 9, 2013

i want to create a save button in sheet 1, on clicking the same the data entered in the particluar cells of sheet 1 should get saved in sheet 2 in given format

View 1 Replies View Related

VBA Script To Clear Cells On New Input

Feb 11, 2013

VBA script I can run on a worksheet that will clear certain cells when I input a fresh value into a separate cell please? For example: By entering a new value into A1, cells B1 and C1:C3 are automatically reset to empty.

View 5 Replies View Related

Clear Numeric Input From All Worksheets

May 26, 2006

I'm trying to create code that will clean up a budget template of numeric inputs so it can be reused. This is as close as I can get but the code still isn't right.

[HTML]Sub ClearSheets()
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
ws.ActiveSheet.UsedRange.SpecialCells(xlCellTypeFormulas, 21).ClearContents
Next ws

End Sub[/HTML]

View 3 Replies View Related

Determining Formula To Choose And How To Input The Data In Correct Fields

Aug 8, 2014

I am trying to save some time converting a cut up inventory catalog number. Specifically focusing on the color code. I have the list of colors associated with their specific part number. The order cannot change or my sheet will mismatch.

What I want to do is convert the # in column A to the color code text in column b so that it matches the translated code in column C? For example

1 I want to tell 1 to = Polished Chrome anytime #1 appears in my column.

What formula should I choose to achieve that goal. As well, how do I know what data to imput into the formula wizard?

Sheet is attached.

I have Cut a few thousand items off the bottom of the sheet. I can apply to additional data left off.

View 4 Replies View Related

Conflicting Results Going From Command Button To Call Routine

Sep 15, 2007

locate the error in this code.

The error is Compile Error
Sub or Function not defined.

It seems to work ok when enabled from within the Command Button
but when the same macro is called from the button, it gives an error at the first-line following Loop.

The code was pasted in a module as Sub End_Input()
and the button was modified with a Call function to the subroutine.

The button code looks like this:

View 10 Replies View Related

Control Button Error :: Suppose To Call A Userform

Dec 27, 2007

I have a control button on a worksheet that is suppose to call a userform. I am using the code

Frm_Customs.show

But I keep getting an error. The button was created from the control toolbox.

View 9 Replies View Related

Auto Call A Procedure By Selecting From A Dropdown List

Oct 30, 2008

I have a worksheet with a Drop Down list (Set up with Data Validation).

All I want to do is a call a procedure when a particular option is selected from the list, without have to run the macro manually.

View 7 Replies View Related

Clear Output Box When Input Dropdown Box's Are Changed

Jun 7, 2013

I got all three dropdowns to be dependent on each other, now however, whenever I change the value in the top Input Dependent Box M39, I would like M43 & M47 to appear blank. I want these two cells to appear blank until you select the dropdown which will allow you to select your values of choice.

View 2 Replies View Related







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