case statement

Please help me code the proper method to using a Case Statement. Here's what I have coded: Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) '---------------------------------------------- ' Test where the double click occurred...

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

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

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

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