.column

  1. M

    Continuous Form VBA Code - is it possible?

    Hello all! I have a combobox with a dropdown of information that has multiple columns (from a query). In a normal (single) form, I normal use the 'on change' event and reference the other various columns that wasn't selected to change other text boxes on the form. For example...
  2. I

    If cell has no value than change interior colour

    Hi, The worksheet cells are currently yellow as standard. The range in question is G9 & continues down the page Any cell that has no value for its interior colour to then be shown as Red until a value is added then it will be yellow again. The code i thought that would do it "shown in red...
  3. C

    vba to sort tables by clicking headers

    Hi, I have two tables of data in a wksht, both with row and column headers. The column headers for both tables are located in Row9 so they align with each other on the sheet and each table is separated with some blank columns. The code below allows me to sort each table by double clicking either...
  4. M

    Skip a Cell if Two Cells equal one another

    I have this VBA, which is great, but in order to optimize it, I was wondering if there was a way to skip cells if two cells equal one another? here is the code: Private Sub Worksheet_Change(ByVal Target As Excel.Range) With Target If .Row = 248 And .Column > 7 And .Column < 556 Then...

Some videos you may like

This Week's Hot Topics

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
Top