vba & conditions

hi anyone can help me on below, I want users to enter specific text (AB, DO, SL) and numbers (-10 to 20) in the cell range(A1:B10, A20: B30). Users should be able to enter only allowed data. if not cell should be clear. I don't want to use data validation impact I need VBA codes. please help...

i was try "Change Font Color Black to White After Found " 0" Value In E Column , And may be I hope Hide row According Zero value. ???" how to possible Conditional Formatting ????

@ How to make One Dropdownlist , Including all table Column Cell Details Show ???? without Dependent Dropdownlist ??? How to show dropdownlist using different -different Columns data , And Add Included Single Dropdownlist ************************************************NOT USE DEPENDENT...

Hello geniuses, I have this challenge here that is staring at me for a while now. I have tried to ignore it but it still pays me visit. I want to be able to use a VBA script to construct grammatically correct sentences. For the start, I will be constructing just simple sentences. S + V + O {...

Hey all, I hope I can get some help here. I have looked around for a solution and have gotten close but not there, it is a tricky one. This is the closest I have gotten: Send email based on date I have an excel spreadsheet stored on onedrive It has 4 sheets with employee details, 3 sheets...

Hi Folks, I'm working with some data that looks like this... CAP8503MKTG04EAOM1CAP8504MKTG01EAOW35-381PO: 0009692CAP8504MKTG03EAOW27-51PO: 0009168CAP8505MKTG01EAOP59-10PO: 000857759-125PO: 000969259-125PO: 0009693CAP8505MKTG04EAOP1 Column B holds the values of 01, 03, or 04. I need to check...

The code below here was written for me by @Fluff some time ago. It's a very wonderful code and I love it. I have added 2 more comboboxes to use as the criteria for doing my filtering but I am stacked with how to get it tweaked. The new comboboxes are: ComboBox3, which will check column Y and...

Hello good people, I am working on a database where people join and have an ID card. ID cards are expired. I want to write VBA codes to highlights an entire row based on different cell values and then copy and paste those values to different sheets according to highlighted rows. A snap is...

Hello Everyone! I ran into an issue with macros and I could use some guidance! I attach a sample excel file for ease of reference. I need to write a VBA code which needs to: 1) Check if a condition is met ("Other" or "Building") -> Column D If "Other", then multiply OMV (Column C) x 0.30% If...

I need to add a vba code for ceiling along with vlookup worksheet function. Can anyone please help? This is my code line: Worksheets("sheets").Cells(i, 24).Value = Worksheets("sheets").Cells(i, 21).Value / Application.WorksheetFunction.VLookup(Worksheets("sheets").Cells(i, 18).Value...

Original Sheet: ABCDEFGHIJKL12UUIDWhatsover1Whatsover2Whatsover3Whatsover4Whatsover5Whatsover6Whatsover7Whatsover8Whatsover9Adjust and filterWhatsover103140542WhatsoverWhatsoverWhatsoverWhatsoverWhatsover5/20/2021 10:00:00 AM5/20/2021 7:00:00...