r1.value

  1. W

    Change Cell Colors with each change of a drop down list value

    I am trying to modify a status board for our hospital operating room that will enable whoever is updating the board to change the color of cells according to a value selected from a drop down box. Unfortunately, I can't use conditional formatting hence the VBA route. I have be experimenting...
  2. S

    Conditional Formatting based on another cells

    hi Friends , Regarding conditional formatting i have checked couple of examples and created the below code however its not working not sure why , Could anyone please review and share where i am making a mistake , also if need to apply this only in the specific sheet names Raw , how do i append...
  3. G

    vlookup in vb.net in retriving data

    Hello!. i am trying to retrieve information from .xlsx workbook to vb.net userform using vlookup function . iam not getting the output . where i am wrong would you please guide . as i am new to .net & vba . Dim r1, r2, r3, r4, r5, r6 As Long Dim rng As Range rng =...

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