case statement

  1. D

    Run code when formula updates.

    I am using this code to update the cell color in F4:F3000 base on the corresponding value in each case, however because I am using a formula to update the cells containing each case this operation is not functioning only the formula is updating, not the actual value in E4:E3000. Is it possible...
    • dhosi439
    • Thread
    • case statement color index offset vba worksheet change
    • Replies: 1
    • Forum: Excel Questions
  2. S

    Show only one sheet in a workbook

    I have multiple sheets within a workbook, but I only want one to be shown based on a user ID/password that the user enters. I have heard that creating a user form and then a case statement is the easiest way to do this, but am having a difficult time setting it up. Any help would be...
  3. J

    Select Case issue

    Hi, I was working on an issue and this is the updated VBA i received from someone to use as a type of validation on a spreadsheet, but it doesnt seem to be working and i cant figure out for the life of me why it isnt. what i originally had in mind is that when information is entered into any of...
    • jostj
    • Thread
    • case case statement column if statement target
    • Replies: 9
    • Forum: Excel Questions
  4. M

    ReDim variable variable Case statement

    For each different case I want the variable ColumnPaste to change to a different column, but its not working. Is using ReDim right or can I do it another way?<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I'm declaring it ReDim...

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