entering

Hi, can anyone tell me the correct way to use dates in a Excel Spreadsheet - I have been entering dates like this : 27/01/2018 which I am told is incorrect. Many thanks

I need some help with VBA code on an Excel spreadsheet. the code below only solve my problem for clearing cell "C6" when entering data in cells C5:D5. I would like it to clear cells "C5:D5" when entering data in cells C6 also. Private Sub Worksheet_Change(ByVal Target As Range) If Not...

Hi all, I am very new to Excel Macros, I created a excel macro in three parts , the first 2 parts consist of font manipulation and data vlookup from another excel sheet, I am finding difficulty in the third part of my macro, its nothing by entering filters to one column and then entering...

We have an issue where end users have to update a spreadsheet with data, which then feeds another application. However, because end users are not following the format, or entering bogus numbers in a field, our data gets corrupted on the end. I would like to create a VB script that checks...

Thanks for looking at my post. I would like to have some code so I can do the following. I would like to have a box pop up with the option to replace a random page in my work book by entering the page number in dialog box. I want the page that will be replacing the old one to be renamed to old...

Guys, i have 2 exel files. I want to get some data from file 1 to file 2. File 1 will be my data entering sheet. I want file 2 to get the data periodically from file 1 How to do it?

Hello, I'm running into an unusual situation in Excel (v 2016 Professional Plus). Upon entering data into cells, I am noticing random borders being drawn around the cell and row. I checked for any "Customized Formatting" rules and none are enabled for the entire sheet yet this behavior still...

So I just want to know if this is possible. Not sure how it would work. I have a form for entering customers and a form for entering invoice details. What I want is when I select the customer on the invoice form, which is in a drop down, that I get a message box with the miles and time from...

I would really appreciate some help!! I am trying to figure out how I can accomplish the following logic: I have files that are assigned to one person, and can switch assignments. I need to locate these switches for specific people. My sheet will look something like what is shown below. The...

I want to prevent user from entering certain characters like "+", ",", "&" etc. I could use Data Validating tool or use Private Sub Worksheet_Change. However, validation in both cases is triggered only after user presses enter. I want it to work like KeyPress event for userform controls - user...