Don't Submit If Cell Contains A Number
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
ADVERTISEMENT
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 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
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
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
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 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
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 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
Aug 13, 2013
SAMPLE FILE "error_finder.xlsx (36.5 KB)" attached...
The VP of our company needs me to create a spreadsheet.
For this s/s I need the following:
Imagine 2 sheets in Excel...
sheet1
sheet2
sheet2 has sequential numbers in column1 starting in row2 with the number 1 until wherever..., so cell A2 has number 1, cell A3 has number 2, etc...
Manually, a user has to fill in certain text next to a number.
This for example would look something like this:
_|A| B
-|-|-----------------------------------|
1| | Error-description
-|-|-----------------------------------|
2|1| Whatever the 1st error would be...|
-|-|-----------------------------------|
3|2| Whatever the 2nd error would be...|
-|-|-----------------------------------|
4|3| Whatever the 3rd error would be...|
-|-|-----------------------------------|
5|4|
-|-|-----------------------------------|
6|5|
-|-|-----------------------------------|
and so on...
All this would be on sheet2
In a cell on sheet1 I now need the number from column A displayed, that has the latest entry in column B.
In the example above this would have to be the number 3 in cell A4, because right next to it (in cell B4) is the last entry "Whatever the third error would be..."
Addition: There are several sheets, each sheet stands for one error listed on sheet1 in column A
sheet1 for example would look like this:
_|____A____|_B_|_C_|_D_|
-|---------|---|---|---|
1|_________|833|933|934|
-|---------|---|---|---|
2| error 1 |___|___|___|
-|---------|---|---|---|
3| error 2 |___|___|___|
-|---------|---|---|---|
4| error 3 |___|___| 3 |
-|---------|---|---|---|
In this example, because "whatever error" (cell B2 to B4 on sheet2) was found on press 934 was the 3rd error (cell A4), the number 3 (cell A4) would have to be populated on sheet1 in cell D4.
View 9 Replies
View Related
Feb 5, 2009
Cell A1 = 3
Cell A2 = 4
Is there a formula to calculate
(3*4)+(2*4)+(1*4)
I need to multiply every integer less than the number in cell A1 and greater than zero by the number cell in A2. I was thinking factorial, but that's not it... Can't remember from my math days.
View 3 Replies
View Related
Jul 18, 2013
I have numbers in b2 to b5 say
10
22
35
50
I have numbers in c2 to c5 say
1000
1580
3000
45000
I have numbers in cells d1 to kq1 (1 to 300) d1=1, e1=2, f1=3 and so on
What I want to do is:
In D2 through to kq2 it puts the number in to the cell that correspnds to a multiple of the number in b2.
That would put 1000 in cells m2,w2,ag2,aq2, ba2 and so on
In D3 through to kg3 it it puts the number in to the cell that corresponds to a multiple of the number in b3
that would put 1580 in cells y3,au3,bq3,cm3,di3 and so on
View 2 Replies
View Related
Mar 8, 2012
Trying to have a formula assign a number to a cell depending on a number in that cell.
Example
In all cells in a range from C8 to G13, if there is a 1, i want the number in C20 to show, if there is a 2, whats in
D20, 3/E20, 4/F20, 5/G20, 6/H20
View 3 Replies
View Related
Apr 27, 2014
I'm making a Excel 2013 spreadsheet that has formula in a column that auto enters a number 1-40 when something is entered to the left of that cell. There are 300 rows in the spreadsheet. I would like to make a drop down list in a column cell to the right that would delete that number in that cell from the drop down list. For example cell C1 has 39, that 39 then is deleted from the drop down list. C2 has 22 in it, click on the drop down list cell and it shows 1-40 less 39 and 22.
View 11 Replies
View Related
Jun 14, 2013
Looking for a way to search an active cell (that has been found using macro) for numerical data and if there is some present paste this in a different location
If there is no numerical data in this this cell then paste a 0 in a different location
An example of the string contained in the cell
Product 7.5% wheat <- i would want 7.5 (or 7.5%) copied to a different cell
or
Product X <- i would want a 0 copied to the cell the 7.5 would be in from the above
I can find the cell to search in, i just do not know the correct way to extract the information I need.
View 9 Replies
View Related
Jan 28, 2009
I have Sheet with 40 employees who each proposes their work schedule, so I have to give each Employee access to the same sheet and want highlight and unlock only those cells that specific employee can use.
Each employee has to login from a drop-down (sourced from Sheet.Employee Master), so their unique Employee Number is in "A13" of Sheet.LOGIN
Can I identify the ROW number and then use that ROW number in a macro to highlight and unlock specific Range of Cells in Sheet.PROPOSED SCHEDULE?
---where "Sheet.LOGIN("A13") = (the value in the cell Col A:"row" of Sheet.PROPOSED SCHEDULE)
I have attached a scaled down version of the Workbook.
Following code is scaled down-- this is for Employee 02 who appears on ROW 16 of the sheet. (macro is same for each employee, just uses a different row)
View 7 Replies
View Related
Jan 19, 2008
Create some sort of formula combination or macro that will: Recognise a cell with a value of 1, 2 or 3 in. If 3 is in the cell, the cell to its left will be counted and added to a total. If the cell that has 3 in changes the value is removed from the total. Ive tried lots of methods but i cant figure this one out!
View 6 Replies
View Related
Dec 10, 2008
can I set a cell in excel so that if a number in a different cell is above a certain number it will turn green and another cell to turn red. I have attached the file.
View 4 Replies
View Related
Jan 15, 2014
I'm trying to grab a number out a cell and use only the number for other formulas.
So in cell A1 I have 2 LK, in cell A2 4 LK, and in cell A3 is 1/2 LK. I want to just pull the 2, 4, and 1/2 out without the LK and put it in the B cells. I'm sure this is easy but I'm thinking slow tonight lol.
A
B
1
2 LK
2
4 LK
3
1/2 LK
View 9 Replies
View Related
