Search results

Excellent, needed to add the "=" on both criteria though to work it. Selection.AutoFilter Field:=2, _ Criteria1:=">=" & CDbl(DateValue(Worksheets("Report").Range("B4").Text)), _ Operator:=xlAnd, _ Criteria2:="<=" & CDbl(DateValue(Worksheets("Report").Range("B5").Text))...

I hope someone can help me. My problem is two-fold: 1. Using two drop-down boxes on a FORM, I want to be able to firstly, select a start DATE (e.g. 22/01/2009) from one box, and an end DATE (e.g. 22/03/2009) from the other box, where both drop-down box fields reference a column listing of DATES...

Does anyone know how to disable the X on the top right corner of a Excel UserForm so that when a user clicks on it to close the form, they get a message saying "Please use the Exit button" (which is a macro button on the form itself)

Does anyone know how to disable the X on the top right corner of a Excel UserForm so that when a user clicks on it to close the form, they get a message saying "Please use the Exit button" (which is a macro button on the form itself)

Scenario: I have two columns on a worksheet, the contents of which relate to each other e.g. 01 Name1....etc. 02 Name2....etc 03 Name3....etc I have a Form with two drop down lists. The drop downs relate to the entries in the two columns side by side respectively. Objective: I want to...

Scenario: I have two columns on a worksheet, the contents of which relate to each other e.g. 01 Name1....etc. 02 Name2....etc 03 Name3....etc I have a Form with two drop down lists and one text box. The drop downs relate to the entries in the two columns respectively. The text...

My Form does not show an event tab. Tried the code without but could not get to work. Thanks anyway. For the benefit of others, I did it this way thanks to Andy Pope. Range("A1") = TextBox1.Text Range("A1").CheckSpelling then unloaded the Form and reloaded it again with the updated cell...

How exactly would I use this code in the module please (novice)?

I want to run a spell check on the contents entered by a user into a field on an active Form. This can be either automatic as user types or manually activated via a button on the Form itself. Can this be done and if so, what code would allow this to take place.

vba Just make another routine and call it from the first call NextRoutine

I want to a number of form fields to auto-populate with data obtained from locations on a EXCEL worksheet, based on the selection made in another field on the form. For example: If "apples" are selected from a drop-down field, then a number of related fields (edit boxes) are to display the...

I want to activate another active (open) workbook only if its name is the same as what I have recorded in a cell in my workbook. If it does return the same name then it is activated, otherwise a message box displays. Example: In my Reports workbook on a worksheet name “formula” in cell B33, I...

I have two solutions for this, the first from another source and the second I worked out myself: Selection.AutoFilter _ Field:=1, _ Criteria1:=ThisWorkbook.Worksheets("Setup").Range("B5").Value, _ Operator:=xlAnd and: TW = Worksheets("Lookup").Range("B3") If TW =...

I need to have the autofilter in Excel reference the content of a cell on a different worksheet (but in same workbook) and use that content as the filtering criteria for the column being filtered. Example: Column 1 in the Table worksheet contains the word "Nelson" Instead of just filtering the...