Search results for query: *

Hi Guys, If you are able to help on this one please. After entering an invalid entry you can move away from the cell and the invalid data remains. I have tried to change the code to clear the cell but it errors, I have tried... If Not bValid Then...

Thank you so much guys. I would love to be able to do this sort of thing, I find it really interesting. Can you recommend any good books that would be a good starting point for learning VBA? I tried to think logically on how to write my attempt but never thought of utilising the Select Case...

Hi, I have been trying to write a change event procedure that looks at a range of cells and checks on whether the cell = "On Hire Previous Year" or is between a date range (Named Cells FYSD and FYED). If either are TRUE then to move to the next cell and if FALSE display a message box. I have...

Thanks Skip, There is some method to the madness!! Once the text boxes are populated these then become buttons that once pressed will pull out information from a data sheet into a Results sheet. So if you would like to look at information by name, click the main Name button, this then...

Hi, I have a sheet called Main with about 50 text boxes that have a formula that links a value from another sheet (e.g. =References!A11) I have some text boxes (buttons) that run a macro that populate the 50 text boxes with different values. (The buttons used are for Name, Location and Age)...

Hi, I have a spreadsheet that will be filled in by a host of users, currently there is data validation on most of the cells. When I tested the validation, it still allows the user to delete data that meets the criteria and then enter data that bypasses the validation. What i wanted to add was...

Thanks PH - I thought conditional formatting was limited to just the cell and couldn't format cell ranges, I need to check that out becuase that would be a lot better

Hello, I have the code below that searches for a value and colours the row. Could someone please adjust so that it only searches Column M. Sub ColorRow() Application.ScreenUpdating = False Dim r As Range For Each r In ActiveSheet.UsedRange If LCase(r.Value) Like "*/*" Then Range("A" & r.Row...

Many Thanks PH, all working as required.

Thanks chaps using your advice I have managed to get both cell addresses as variables. What I cannot get to work is when I try to use the string variables in a formula. It's something to do with "=" - Code below not working, thanks for your help. Sub ServiceHistory() Dim lastCell As String...

Hello, Could someone kindly help me complete this procedure please. I have set a variable to the ActiveCell and I wish to pick up the cell reference (eg E3) rather than the value. The procedure below works but brings back the value rather than reference. So the cell formula will look like...

Perfect!! Making it work for the spreadsheet now and it's doing the trick....so much quicker wow!! Thanks Gruu

Hi, I have a spreadsheet that uses the formula below to look at four criteria and return the value where all four match. I am now trying to incorporate this into a larger spreadsheet where this formula (adjusted to work) will appear on every line (approx 5000). I have changed it to work but...

Thanks Skip, Okay i have been away, messed around and got something working but it still requires all fields to be filled in. I have created 4 new worksheets for each search criteria, Account, Code, Range, Controller Procedure allselected() is assigned to a button. Procedure accountsearch()...

Hi, Presently I have 1 button that has the macro below assigned which searches Site Print Column A and matching the value with Cell F9 in Criteria and then pulling the entire row into Search Results. Sub accountmoving() Dim c As Range, d As Range If Range("F9") = "" Then MsgBox "Please...

Thanks guys, have used Skip's method with success. Kind Regards

Spot on thanks Skip

Ah, reposted into correct forum.

Hi, I found the program below and have amended it to suit the needs. The needs have changed. Currently the program would look at the date entered in F15 and pull into Search Results all the rows where that date appears in Column I of the Site Print Worksheet. Now a Date to field has been added...

Hi, I found the program below and have amended it to suit the needs. The needs have changed. Currently the program would look at the date entered in F15 and pull into Search Results all the rows where that date appears in Column I of the Site Print Worksheet. Now a Date to field has been added...