Macro To Submit A New Income Into A Table
Mar 8, 2007
I m making a spreadsheet for Income and Expenditure Calculations. The problem i'm having is creating the macro to submit a new income into a table.
As you can see from the above image ive got a cell to type in the income amount and a combo box to select the month that it applies to, my problem is the VBA code for the "GO" button.
I started by trying to name the value from the combobox as something e.g. selectedincomemonth = ComboBox1.Value
However this wouldnt recognise as an object, what do i have to do to get VBA to recognise what has been selected from the ComboBox, and could somebody help me with the code to search what has been selected in a list.
View 9 Replies
ADVERTISEMENT
Jan 13, 2009
I've got this macro I pulled from some other site and it's not working quite like it should. In my eyes at least...
OK, first, a little back story...
At work we used to have a custom Outlook form that was used for submitting office supply order requests.
The form was stored on our public drive for all to access it when needed.
Well, the form broke somehow and no one knows how to fix it.
We need something to replace it.
Keep in mind that we have no access to the Internet, nor can we send/receive emails outside of the company.
So, I created a simple form in Excel with a drop-down list of all the items in the supply cage, a form field for the senders name, etc...
What the macro does is, it copies the active worksheet the form that just got filled out) to a new workbook (dropdown data is on other sheets in the original) and then opens Outlook (2003) to send it as an attachment.
The only catch is that when the email arrives the only thing filled out is the form fields, NOT the drop downs...
The ONLY way I can get the drop downs to send with data in them is to leave the original open.
Oh, and for some reason every time I sent this while testing, it would name the attachment Book1, Book 2, Book3, and so on. I can't have that...
Here's the code I'm currently using:
View 9 Replies
View Related
Jul 12, 2014
I cant find out of include the submit button. I can fill out the field but not submit.
Use excel 2003
[Code]...
View 14 Replies
View Related
Mar 4, 2014
I have an excel form with a command (submit) button that opens up Outlook when clicked. I am looking for a way to have this submit button disappear when the user selects a specific item in a drop down list to make sure they do not email the form when it is used for a promotion (Promotion would be selected in the drop down).
View 8 Replies
View Related
Jun 26, 2009
I have a spreadsheet that contains entries for each order of a product and the product amount. What I want to do is have a summary of this for income. So, if there is a date completed for the order, I want a sum of this for the month.
Order No. Order Amount £ Date Ordered Date Complete
A2 B2 C2 D2
View 9 Replies
View Related
Apr 21, 2009
I'm trying to write a function that takes a single argument grossIncome of type Currency. It should calculate the tax on any income using the following tax schedule
1) If income is less than or equal to $15000 there is no tax.
2) If income is greater than $15000 and less than or equal to $75000 the tax is 15% of all income greater than $15000
3) If income is greater than $75000 the tax is 15% of all income between $15000 and $75000 plus 20% of all income greater than $75000
Then I want to write a sub that asks for the user's income and have the above function calculate the tax on the income and say the tax in a message box.
View 2 Replies
View Related
Dec 7, 2008
I am a car salesman and made a sheet to track my sales from month to month. I would like to make a formula to only add the entries that fall between the 1st and 15th of each month to show me what my check will be for the first half of the month. Column A has the dates and column J has the amount. I need to calculate only the first half of the month in J24 to know what my mid month check will be......
View 3 Replies
View Related
Jan 26, 2008
I am working on a tax deduction formula for payroll. I need 3 formulas. The first formula needs to find two cells that are on the same row based off the employees status and gross income.
View 5 Replies
View Related
Jul 27, 2013
I am trying to use vlookup on the the income statements I am using. I have a workbook called overview with all the months and need the "total" of each month to appear automatically. The previous vlookup formula does not seem to be working.
View 13 Replies
View Related
Mar 27, 2007
i wanted to ask that in excel i have different values, if i post on ere its so long actually i cant post it coz it will tke ages to do so; so wot i wanted to no that how to estimate total income of values? and how to estimate annual profit/loss?; i mean the formula to find these terms.
View 9 Replies
View Related
Mar 3, 2014
I have created a table for a business to monitor all income and expenses within a financial year of that business. This table contains raw data for example, date, income/expense, wholesale amount, retail amount etc. So when the business makes a sale for example I enter in the date of the sale, type of sale, wholesale and retail amounts etc, and i do this for every sale I make.
What i need to do is figure out a way to calculate the average monthly and weekly income to date so as the financial year continues and i make more sales i will continue to enter more data into this table and it will automatically adjust to the new weekly or monthly average income. This way i always have an actual and live average for every cent the business has made as the year progresses and i can use this to budget for the business. I would also like to know what the income is for the current week or month. that way i can say for example on average the business makes $4000 a week and in this week it has made say $5000.
View 13 Replies
View Related
Jul 18, 2011
I am trying to get the formula for calculating yearly rental imcome. The range is 10 years and the interest is 34%. The first year payment is 42,000 and the 10th year payment is 56,000. I can't figure out how to do the other years. The principal is 325,000 and the sale value is 425,000.
View 4 Replies
View Related
Mar 5, 2013
I have written an spread sheet for judges to submit results for candidates. When the judge hits the submit button, the answers are transferred to an answer sheet.
I want to add to my code a line that will remove the possibility of a score being submitted for the same candidate twice - so once a candidate has had a score submitted, it can not be over-rode. Although I wrote the code myself, I am struggling to work out how I define the cell that I want the macro the check. E.g. the line currently checks for cell "B4", but I need it to check for the cell/s that the macro is going to submit to. Currently I have:
VB:
For Each sh In ActiveWorkbook.Worksheets sh.Unprotect Password:=yourPassword
Next sh
If Sheets("Answer Sheet").Range("B4") > 0 Then
MsgBox "You have already submitted a score for this candidate."
[Code].....
View 1 Replies
View Related
Feb 16, 2012
is there way way i can allow users to hit enter in a Userform to submit what they have? instead of haveing to tab over or click on a button? or even make enter run the button function?
View 1 Replies
View Related
Apr 25, 2007
I'm working on an order form in excel and wondered if someone can tell me if it's possible to add a 'submit button' to a worksheet (order) that would do the following,
1.) print 3 copies (orders) of the current sheet
2.) create a new worksheet in the same workbook with a new order number (a specific cell in the worksheet) one higher than the current one. Also naming the new worksheet with the new order number.
3.) Save the current workbook.
Maybe I'm getting a little ahead of myself here but any help would be much appreciated as I'm really rusty at this...
View 9 Replies
View Related
Feb 18, 2010
I'm trying to create a program that will automatically log in to a website that requires a username & password. I am able to enter the username and password in the correct text boxes, but I can not get the form to submit to approve the login. It refreshes and removes the password.
I have attached my code. The web url is inside it.
Sub IE_login()
Dim ie As InternetExplorer
Dim C
Dim ULogin As Boolean, ieForm
Dim MyPass As String, MyLogin As String
Set ie = New InternetExplorer
ie.Visible = True
ie.Navigate "https://applications.dacgroup.com/login.aspx"
'Loop until ie page is fully loaded
Do Until ie.ReadyState = READYSTATE_COMPLETE
Loop
View 9 Replies
View Related
Sep 26, 2009
I have the following code that works just fine half of what I need it to do. The line that adds the text in column A functions correctly but the code for column B fails because column B is empty by default. The goal is to have the information in column B on the same row as column A. As well as adding two more cells on the same row as column A. The two new columns would be E and G and should be in the same row as the information from Column A. with formulas copied from e2 and g2.
View 3 Replies
View Related
Mar 13, 2013
I want a Macro that I would like to assign it to Control Button on Spreadsheet 1. When the user clicks on this Button only "Selected data" i.e. Cells A3, B4, C5, E5 will be transferred to Spreadsheet 2. The data transferred into Spreadsheet 2 should be inserted in the first available row and hence not override other data. Also, I have a question, both files will be sitting on the same shared network path however,for the update to happen to we need to have both files opened at the same time? If yes can we design something to update Spreadsheet 2 without having it opened?
View 2 Replies
View Related
Oct 30, 2013
How do I calculate the days between submissions by manager in the below example?
Customer Submit DateManager
2361047/2/2013 Jackson
2361667/19/2013Andrews
2480589/30/2013Smith
2480589/30/2013Smith
803139/30/2013Thompson
[Code]...
View 1 Replies
View Related
Feb 10, 2014
I have a simple form built, but the data validation is only partially working. I've attached a sample workbook.
basically, when a user tries to put in a letter in the GP interaction field rather than a number, it prompts user to re-enter. This part is working, except when the submit button has been clicked, the field clears. the field clears, it prompts the user to re-enter.
form based input - Copy.xlsm‎
View 3 Replies
View Related
Jun 2, 2009
I have made a userform with some code in it that I would like to be on the spreadsheet itself instead of a user form? How is this done? The problem is getting the below code to work at spreadsheet level since I did not write the code below. I have the button the spreadsheet, but I don't know how to see the name of the button or assign the below command to the button.
I need a macro to copy data from the two combo boxes that appear on the spreadsheet and place the data into cell A for the first combo box and cell B for the second combo box.
View 4 Replies
View Related
Jan 31, 2010
creating the user form using the submit button. Ive used a tutorial to create the form and the code, but it doesnt work i get a subscript out of range error 9)
Here is what i have
Private Sub addpatient_Click()
Dim RowCount As Long
Dim ctl As Control
' Check user input
If Me.txtfirstname.Value = "" Then
MsgBox "Please enter a First Name.", vbExclamation, "Patients "
Me.txtfirstname.SetFocus.........
View 11 Replies
View Related
Nov 23, 2013
I am new to excel macro. Want to invoke a page and click on submit button. Getting "Object doesnt support this property or method" error on the line "Subm.Click"
My code is,
Sub Macro1()
Dim IE As Object
Dim URL As String
Dim Subm As Object
URL = Range("B3")
[Code] .........
View 1 Replies
View Related
May 26, 2014
I am trying to get data from this site in excel. I need to select options from drop down menu (like bank name, balance sheet and date).
View 5 Replies
View Related
Jun 4, 2014
I am currently running VBA when ComboBox1 is selected ComboBox2 shows specific information based on lists in the spreadsheet.
Now I would like it if ComboBox2 showed "Business Improvement" then ComboBox3 will show information set in that list.
Also, my submit button isn't working and I can't find out what's wrong using the debugger
View 7 Replies
View Related
Jul 19, 2012
I have a form with a number of fields that once submitted paste the data in the next blank row in a sheet (as below). A user will input the date of the week commencing in a text box on the form (Calendar1) and a number of days in another box (txtSupp). I need it to submit the value of "txtSupp" in the same row on the sheet under the right date of the week commencing based on date in "Calendar1". Rows L1 to EJ1 of the sheet have the date of the week commencing starting from 02/04/2012. E.g. L1 = 02/04/2012, M1 = 09/04/2012 etc.
Private Sub SubmitForm_Click()
ActiveWorkbook.Sheets("Data").Activate
Range("A1").Select
[Code].....
View 1 Replies
View Related
Mar 18, 2014
I would like to set up a maintenance register where I would have:
worksheet 1 - a page where staff can choose a location and choose a maintenance issue and hit submit
worksheet 2 - after they have hit submit the detail will appear in designated cells in worksheet 2 (a ledger of maintenance issues). so each submit should send the info to a new line in worksheet 2.
I have a basic knowledge of Excel and have used formulas and functions before but not VBA/Macros. Any step by step through setting up the submit button and macro correctly?
I've tried to do Worksheet("Register").Range("A2").Value = Worksheet("Request").Range("A1") after installing a push button but all I get is errors.
View 5 Replies
View Related
Sep 26, 2012
I have created a simple userform that is linked to a button on sheet1. When the data in the userform is submitted, I set it up so it goes into a database under sheet2. The problem is, I don't want anyone modifying the entries in the database. Usually I would protect the sheet with a password, but when I do that, there is an error when the userform is submitted. The only thing I can think of is to hide sheet2, which doesn't seem like a great solution.
Is there any way to protect my database from being modified yet still allow the userform to be linked to it?
View 3 Replies
View Related
Mar 6, 2014
We are trying to find the median of a large set of numbers to calculate the median income in 2010. For an example we have 8,379k people with $2500 average income, 9,783k with $7500 average income and so on. How can I calculate the median average income of such a large amount of entries?
View 8 Replies
View Related
Apr 14, 2009
I would like to have a macro to automatically generate a statistics table (on the "statistics" tab) with the 5 following fields:
Fragment names / # samples / # of failed samples / % of success / # of variations in the fragment (SNP). At the bottom of this table, I would like to have a cell with the average % of success for all fragments. The data to generate these statistics are on the "gene name" tab (please note that this name will change every time I will work on a new gene). To make things easier, I think the macro should be run from this tab.
1. The Fragment names are displayed in row #5. I use one column per variation per fragment. If one fragment has 3 variations, there will be three columns and I will merge together the fragment name cells. The fact that some cells are merged can be a problem when copy-paste to the stats table (as I would like to get rid of the merging).
2. # of samples corresponds to the number of cells in blue in column A. The number of samples can change from one report to another but is always constant in the same report.
3. # of failed sequences. In the table, I type "Failed Sequence" (if the analysis has failed) and "Missing Sequence" (if the analysis has not been done). When a sample is failed or missing, it is for the who fragment, no matter how many variation there is in the fragment, so I usually merge the cells of all variations for this failed sample.
4. % of success: this is quite easy #sample/#of failed+missing sequence for this fragment
5. # of variation is equal to the number of variations for this fragment (can be 0, 1, 2, etc.). When there is no variation in a fragment, I put '-- in all cells of the corresponding fragment on the "gene name" tab. Fragment 3 on my file is an example of 0 variation.
View 3 Replies
View Related
