enter

I am working on a project for a companies payroll. What I am doing is taking payroll data and using a button to automate and organize the data to enter into our accounting software. I am moving along nicely, but the problem I am seeing is when an employee leaves or are added and their VBA code...

Below I have VBA for a user to enter a date and for that to be entered into a specific cell on the active sheet. I do not have a lot of experience with Or statements. I want to add an "or" path for a checkbox to be ticked, if this is the case then yesterday's date; formula =today()-1 would be...

Hi, I have a formula that says =if(A1>A2,"True","False"). However, I want the ability for the user to change the sign in an other cell. So let's say in cell B1 they can enter ">" or "<". I want to write a formula something like this =if(A1&B1&A2,"True","False"). This does not work. How can I do...

Driving me insane right now. I have multiple users on the same spreadsheet. When a value is zero some enter 0 and some enter - Is it possible to format the cell so if someone types - it automatically changes to a zero Thanks

Essentially have a VBA workbook where it allow the user I am giving it to to enter simple parameters like enter something in cell A1 and A2, press Enter and it will run my script and performance a task. But they are not able to go into the VBA editor or see my VBA code. Is this possible? Any...

Would you please be so kind as to show me how to create a formula in Cell F3 after entering any (x,y) coordinates from range B2:D4 and then it will automatically display the corresponding number in Cell F4? Also, vice versa, how to create a formula in Cell F7 and enter any numbers from...

With the help of this Forum I managed to build an Inputbox code that enables me to input golf scores for each player in turn. With a blank score entered if the player didn’t play. See code below. If possible, I am now wanting to use a UseForm to do the same thing. On the worksheet, each...

I have a button which shows a Pop-Up Box asking the user to enter a name of a staff member. Is it possible to edit the Pop-Up so that instead of showing a free text box (where the user can enter anything), it shows a combo box instead which lists the staff names? If it helps, I currently have a...

I need some help building a macro that will change a cell color when the user hits "Enter" from inside that cell. The cell typically contains a formula that calculates growth by a value entered in an adjacent cell. However, I want to allow the user to over-ride the formula with a value of...

Hi all, I am using an Excel automated sheet to prompt users on what to enter into another program. After they switch focus to the other program (not Excel) to enter data, when they come back over to the Excel sheet, the button shape that I have added with code attached only works on the second...

Hi team, I'm finding what I want to do hard to articulate, however I have 10 Columns with titles of Projects, I then have 5 Rows with Services. Each service has a Dollar amount Per Service eg $220, $118 etc. I want to enter in each Column a service used each month, and rather than show the...

When I rt click a column or cell and set the format for time and date and enter [4-25] I get [1/13/1900 12:00:00 AM] in the address field and [4/25/19 0:00] in the cell. First, why are the options grayed out; they seem to be working otherwise and is there a way to get the program to plug in...

Need help on creating a macro for this scenario, I hope this to automatically run as I change value. If I enter 5 on C2 the macro should put "X" on D2:H2 If I enter 3 on H3 the macro should put "X" on I3:K3 This i currently what I have but it is hanging for some reason. Private Sub...

I need help with a macro. I've found lots of macros online that a described to do almost what I want but my VB grasp is never enough to modify it to my needs. I've bought a VBA book to teach mycself but I'm afraid I need this spreadsheet too soon to wait for me to upskill. I'm creating a date...

A very helpful board memeber gave em this code to open an input box as a search for data in the column Range("c2").AutoFilter 3, InputBox("Please enter the search letter") & "*". I am trying to get it to un in column a instead so I entered Range("a2").AutoFilter 1, InputBox("Please enter the...

Hi all, In Excel 2016, I would like to copy and insert a fixed amount of rows (containing formula's and graphs), by a value, which I have entered. For example: a pop up displays, or I enter a number: 'how many tables do you have?' : enter x amount of tables. Then the macro automatically...

I type this: 12345678987654321 And I get this: 12345678987654300? Formatted as number. Thanks, -Jim

Hello, Is there anyway to format a cell in such a way that if I enter an integer then in the cell I see just the integer, then if I enter a decimal (say 6.5) I see 6.5 in the cell, Currently I can't get the format to automatically change, I see 6 (when I input 6) and then 7 if I input (6.5)...

I have an application that generates a file that include VLOOKUP formulas, but the result is not calculated automatically. I need to manually press F2 + Enter to have the result calculated. Facts: - I already set: Formulas > Calculation Options > Automatic - B6:B17 and B19:B26 have the...

Hello to all! Hope you can help me. I have an issue in an excel file that i want to disable 'enter' so users can navigate in excel sheets with arrows only. is there a simple way to de-activate the enter key only for the specific excel file (lets call it test.xlsx thanks!! Andreas