vbblack

  1. D

    vba IF Like with spaces

    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...
  2. S

    Conditional Formatting to the Pivot Field instead of Selecting Cells

    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...
  3. R

    When is black not blan

    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...
  4. D

    Some help with ranges and offsets

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top