restriction

Good afternoon A bit of a strange one on a process I'm currently changing. Currently, the business emails payroll data to the payroll team in a variety of weird and wonderful formats for them to manually process. I've streamlined the process by standardising the submission using VBA and...

Hi good after noon, I am using an excel chart and finding solution to restrict cells in a row for writing, if a particular word will write in a CRITERIA cell the restriction will remove to allow for writing. <tbody> A B C D 1 DESCRIPTION VR / KYC AMOUNT 2 Transfer (ALLOW TO WRITE)...

Hi everyone. My first post here but used as inspiration many times. The original data is on A1:F14 and the desired outcome in K1:M14. I`m looking to use less columns to show attributes for each ID on column A. The single restriction is that the unique strings must be placed on the same column...

I'm using Excel custom data validation to restrict entry in A2, if A1 is 0 or blank. The formula =A1>0 works just fine if A1 is a number greater than 0, but if A1 is blank, the restriction does not work. Put another way, I want a blank cell In A1 to be treated as if it was a zero. I've tried...

If a user fills out one cell, I want to restrict them from filling out another cell within a certain range. And if they try to do so, I want them to be prompted with a message box explaining the restriction. eg. <TABLE style="WIDTH: 155pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0...

Hi all, Could somebody guide me on this please? How would I ensure that only one cell across a range could be filled? E.g. across five horizontal cells, say A1:E1, I want to restrict that only one of those cells may be filled. I.e. if A1 is filled (with text or numbers), then B1, C1, D1, and...

Hi. I am using VBA on Microsoft Excel, and have created a userform containing several text boxes. On one of these text boxes, I am trying to implement a character limit, restricting users from entering more characters than a specified limit (In my case, the limit needs to be 8 characters). I've...

I am currently creating a userform on microsoft excel using VBA. This userform is for a car company. I have a text box for the mileage of the car, this text box is named txtmileage. I am trying to figure out how to create a character restriction, making it so only numbers are valid inside the...