Can I Add A Submit Button To Worksheet
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
ADVERTISEMENT
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
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
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
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
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
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
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
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
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
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
View Related
Feb 8, 2010
i'm using excel 2003 SP2. I have several sheets with the same buttons. And i have a final sheet where I collect a summary from every sheet. I want to create in my summary sheet a button that runs all the buttons from the other sheets, so i can get all the info.
View 3 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
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
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
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
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
Oct 22, 2008
Running into this issue of "transworksheet macros"
I have a master "update" commandbutton on sheet 1. I have two sub "update" buttons on sheet 2 and 3 respectively.
What I would like to do is have the user click the master button, that would "click" the two sub buttons so they run their respective macros on their respective worksheets (within the same worksheet.
I have tried pasting the macro code in the master button, telling it to select the sub worksheet and then run the macro, but the marco runs itself on the master worksheet instead.
View 6 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
Dec 27, 2008
I have an existing button which has either a macro or hyperlink assigned to it which links to another worksheet within the workbook. I would like to change the worksheet it is linked to. I have tried right click - edit hyperlink and picked a different sheet, and also assign macro - record new macro. I have even removed hyperlink, then inserted new but no matter what it still goes back to the same sheet.
I am in this position after copying and pasting an existing button. I'm not sure how they designed it from scratch so I would really prefer to just change the link.
View 2 Replies
View Related
Jul 13, 2008
I have made a little program for a customer at work which has 4 different worksheets.
Each worksheet works out a cost based on different prices.
I would like to make a 'Welcome' worksheet, with buttons on it so my customer can click the button which corresponds to the option he would like to cost, and then excel automatically selects that worksheet.
how to create buttons but don't know the code to but behind it. It would be nice to also hide the other 3 worksheets when they have not been selected by the welcome page.
View 9 Replies
View Related
Jul 26, 2008
creating a button (using VBA code) in a excel worksheet that can initiate a range of output data in a col (say (C1:C100)) by activating the therein formula of each cell (same as what F2 does) and then entering the cell.
Actually I have to do manually each time for each output cell after opening the worksheet that I don't want.
View 9 Replies
View Related
Oct 28, 2008
I have a button on a worksheet that activates a macro, the macro is stored in a "personal.xlsb" file. This file is copied to several users computers so they can use the macro, problem is once the button is assigned to a macro from one computer all the other users can't use the macro. What can I do to make this macro work on all computers? (Less placing yet another button on the tool bar).
View 2 Replies
View Related
Apr 6, 2009
I am trying to make a button that puts the formula back into the cell after a manual entry
View 3 Replies
View Related
Dec 24, 2012
I want to assign macros to buttons from VBA. I know that buttons have a TopLeftCell property and I've used this before to point at cells around the button but not the other way round.
What I'm trying to do is have excel assign a macro to a button when the workbook is created (if thats possible - if not then just whenever it's opened the macro can be reassigned).
The recorder gives me the line of code:
Selection.OnAction = "ThisWorkbook.ImportJobsButton"
so I really want to change Selection for something that points at the specific shape. I want to do this with a few shapes.
View 1 Replies
View Related
Jul 27, 2007
I have buttons on each of my sheets, when one is clicked code is called in my module ("modAPI"), and from that code I wish to disable and enable certain buttons, and/or change the caption of those buttons. However when I try to do:
With ws
btnRefresh.Enabled = False
End With
I get Error 424, Object Required. I've tried recording a macro of what I wish to do, and it gives me ActiveSheet.Shapes("btnRefresh").Select, but this doesn't give me the option to enabled/disable or change the caption of the button.
View 3 Replies
View Related
Jul 10, 2014
I've been looking for a way to save a worksheet as a PDF document and place it in a folder in Documents.
View 4 Replies
View Related
