Search results

I'm not sure what you mean by Userform. I do need to use Excel as we're using a macro to then output the data in the format required to be uploaded into another program.

The issue there is I already have a Data Translation in Column A to provide a warning if the text entered is: A.) Longer than 28 characters B.) Use of any lowercase letter I don't think I can do both, right? Well, maybe I can and maybe just the error message/warning would be OK. Here is what's...

That only solves my first 2 requirements which I already had. I want to key off of A column. If there is data in A2, there must be an entry in J2 before entering anything in the next row - A3, A4, etc.

Hi folks! I am a bit stuck here... Trying to combine some data validation here in my Excel form. I am able to get the error message working to force a 5-digit number to be used. However, I am having trouble also forcing an error/error message if/when the users skips the line when there is data...

Yeah, I'm an idiot... The issue is that I had the cell FORMAT set to 'GENERAL'. Once I changed it to 'TEXT', it worked fine. It was taking any long # string and converting it into ########+eXX which would keep it under the character limit, but obviously still not correct.

I tried that and it still allows entry of more than 28 characters, as it was doing previously:

I am trying to set the character limit of my cells to 28 and force the characters to be uppercase using Data Validation so the user receives an error if either condition is not met. I have the uppercase portion working fine, but cannot seem to get the length to function correctly. It seems Excel...

Ah, okay. Thank you again for the help.

Such a simple problem and simple fix. I didn't even think to check that. Thank you very much! Can I ask what gave it away and told you the cell was Hidden which was causing this issue?

Doing some messing around with the form, F2 and double-click both clear the contents of any of my cells which accept text. I want the F2 or double-click to allow the user to edit and KEEP the already-entered text within the cell. I only want the actual DELETE key to delete the contents of the...

I have a VBA and Macro enabled worksheet which is working perfectly thanks to the help of the guys on here... except I have a cell for people to add comments and if they try to open the cell back up to edit/add information, it clears out all past information. I want the information to be stored...

I think you have fixed it, thank you sir! Everything appears to be working properly and I have not yet been able to break it. Thank you very much for all of your help. Now I'll try and read through the VBA and figure out why it is that way so hopefully I'll learn for the next time. What is...

Ah, I think I see what you are saying with the "IF" condition for Phase Status. What would be the best method? Should I have VBA put the formula back in if the cell contents are deleted? I assume I should use something similar to what I used to re-format the columns like "Project Name" or...

Very odd. So I downloaded the updated sheet you attached and ran it... the Timestamp worked. I didn't save it, re-opened it and now it is not displaying the Timestamp for the Phase Status. The "Design Phase" and "Production Phase" Phase Status drop-downs are not working. So, I closed Excel...

Thank you for your help, but I do not believe this fixed my issues. Now when I make a selection for all of my Tasks, the Overall Task Status correctly displays "Complete", however, I should then be able to select my Phase Status from that cell's drop-down menu. When I click into that cell...

I'm not really sure to be honest. I tried to completely unlock all of the cells of the sheet first by highlighting all and going to the CTRL+1 menu where you can lock/hide cells, but that did not seem to change anything. It still seems to throw an error code. Currently there is no protection...

I have also tried to lock the whole sheet and unlock certain cells through VBA. It then appears to break at the point where I want to validate the Task Completion before allowing "Phase Status" to be chosen, at which point it does not allow me to choose the Phase Status. Also, if I keep my...

Sorry for the delayed response, I have been working on other projects and this has been pushed onto the back-burner. This week I have some time to get back into it though. When I do it this way, it seems to cause me errors. I started off by clearing "Locked" from all of my cells and then only...

I have a worksheet I'd like to add protection to. When I add protection within Excel, it seems to break my VBA functionality. Do I need to add protection within VBA rather than Excel? If so, does it matter where within my current VBA code this new "protection code" is placed? I want to be...

I am still not following how to split them up, I'll have to look into that more. Up to this point I have just been working with the main VBA screen that pops up. In your example with the broken out module, I do not see the timestamping VBA code, but it appears to still have that functionality...

Your attached example does not seem to function as desired. It allows me to select the Phase Status without any regard for the Task Status cell showing "Complete". Will keeping things as-is cause problems? Your code looks quite a bit different than my current/original VBA.

I have figured the timestamping issue out... The problem was that the VBA had "APPROVED" and "APPROVED W/ COMMENTS" instead of the correct "Approved" and "Approved w/ Comments". Remember CAPITALIZATION MATTERS.:DD

Yes sir! Thank you very much for your help. Why did you add the VBA "Application.ScreenUpdating = False" at the top though? Also, my timestamping is still not working... I am not sure why. The VBA Nebu attached is shown below. I simply duplicated this code to add my other constraints I...

I took that VBA and tailored it to my worksheet, but it does not appear to be working. I have some other VBA code that is supposed to function to create a timestamp when a certain selection (Approved or Approved w/ Comments) is made. I am wondering if it is due to a problem with the order I am...

I have a Data Validation drop-down list that I'd like to not allow to be used unless another cell displays certain text. Is this possible? Specifically, I want this Data Validation (titled "Approval_List") to look at Cell D9 to see if it displays "Completed". If it does not display...