Recent content by sunnyp

HOW to load Image Based on cell value??? Cell A1=1 cell B2=(Image Based on Cell A1).

Thank you, it works with =IF(OR(A1={1000,2000,3000,4000}),TEXT(TODAY(),"mm/dd/yyyy") but i get FALSE when there is no data, would you please show how to get rid off this error?

Here what i anted to do, A b 1000 or 2000 or 3000 or 4000 =today's date in mm/dd/yyyy format.

If cell A1=1000, i need cell B1=today's date.

I have found the code to encrypt the cell here is the example: Option Explicit Sub test() 'this sub is only present to demonstrate use of the function! 'it is not required to use the function. Dim r As Range, retVal, sKey As String sKey = Application.InputBox("Enter your key&#34...

iS IT POSSIBLE TO ENCRYPT SINGLE CELL IN EXCEL

Thanks Narayank991 for your help.

A B c D 4/5(date) 4/6 (Date) =B2-A2 I wanted to get in D2= State Tax:-[4/5] through formula when i put d2= If(C2>1,"State Tax:-"&TEXT(A2,"mm/dd"),"") i get State Tax:-4/5 but i wanted to get State Tax:[4/5] how do i do this cell A2 and B2 are...

i wanted to format date in[dd/mm] like [4/5] in parenthesis.

date format in[dd/mm] format

How to create a confirmation letter from excel user form.

Can You generate random number with numbers and letters together.

Is it possible to link two or more different excel file together and when you add a spin or scroll button to sheets it will scroll through all the file back and forth.

How to do credit card number format in excel through vba. I tried other formula it did not work , problem is last digit turn in to 0.

Thanks That's it Thank you very much for your help.