vbblack

Hi all Does anybody know the symbol for space when doing a like or am I missing something this does not work If Me.TextBox5.Text Like "*At At*" Then Me.TextBox5.ForeColor = vbRed Else Me.TextBox5.ForeColor = vbBlack End If I also have this below looking for a...

I'm trying to apply a formatting condition to a pivot field, the script below does that but applies Formatting to "Selected Cells" of the Pivot Filed and makes it a static cells range, instead of Pivot Field Values of the pivot table, where as the same can be done manually. <code style="margin...

I have written code to highlight any word found in a cell from a list. eg. Look for the word "BUBBLE" in a search range and if found then change the color of "BUBBLE" to vbRed and put the number 1 in the next cell over. I then go through another list to check for false positives, eg. Look for...

I have created a little calculator to make my life a bit easier at work on an excel userform. It is composed essentially of 3 columns and a variable amount of rows dependant on the case. The form is rather like a table where my first 2 rows are headers as below. Underneath element has drop...