Search results

Hello Friends, I have a sheet which has conditional format applied to a set of cells. I applying a VBA script (pls refer below) in this sheet to hightlight the "ACTIVE CELL" but when I am doing so, the current existing conditional format applied for other selected cells gets deleted. Is there a...

@ SP Just refered to the shared excel and I must say you are highly skilled in VBA scripting Would you mind teaching few basics of VBA to me?

Hello Friends, Is there a script to set a "Combo Box" in a blinking mode? I'm aware of the VBA (below) to set a cell in a blinking mode Sub Auto_open() With ThisWorkbook.Worksheets("Hiring Dashboard").Range("A1").Font If .ColorIndex = 3 Then ' Red Text .ColorIndex = 2 ' White Text Else...

Please keep an eye on this forum because I might need your help again. Thanks Raja

@SP I really dont know how to convey my Thanks for your timely help. You have been very supportive and patient in resolving my query. Thank you very much, bro, I wouldnt be able to complete my task without your inputs Regards, Raja

@sgmpatnaik: Heartfelt appreciations for your efforts, bro. But somehow I am unable to get this "Allow Range to edit" option. Let me share the procedure of how I protect a sheet: 1) Select complete sheet (Alt + A) 2) Format cell-Protection-Uncheck Locked cells 3) Select cells which are...

@ sgmpatnaik Your solution has indeed helped me but now I'm facing a new problem. Since my sheet is filled with formulaes and I need to protect the sheet but when I do this, the code is throwing an error Is there a way to over come this? Thanks Raja Kamarthi

@ sgmpatnaik This is absolutely awesome bro,many many thanks for this piece. Your code does the magic I was looking for. Once again, Thanks a ton Regards, Raja

@Kaushik: Thank you so much for your time and input. Your code works like a charm.However I still seek your help as I am facing a glitch. Since my sheet is filled up with formulaes, when I double click on any of the cell, the cell goes into "EDIT" mode and the formulae range is displayed.What I...

Need a VBA script to replace a particular blank cell with an active cell value for e g in the spreadsheet cell A1 is blank and when I select cell B1 which has XYZ value, this value should be reflecting in cell A1 and in the same way if I select cell C1 which has “123” value then the same should...