Search results

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.

That is not what i am looking for. I wanted to fill the row when i put Room 101 so that correspond row will fill the data when i put another room 103 then it will fill 103 row

Here is my sheet where i have user form when i put Room # 101 in the user form text box 1 all the data will fill the row correspondence Like below Room # Guest Name Rate Ldg Paid Ldg Code 101 Sunny $55 $59.99 2 102 103 104 105 106 107...

Now you can excess this file SirJB7.

Is it possible to convert lotus 123 file (Macro) in to excel 2010. If does convert how? Here is the file https://docs.google.com/file/d/0B2kKysKalbcNU25ic1JZSEFPc0k/edit

I will upload the file https://docs.google.com/file/d/0B2kKysKalbcNZ2UtQktNekRITmM/edit

I need a macro that put coma in between names in column B

Can you please give me a sample . Thank you.

Is it possible in user form when you have user form like this name ___________ Number_101_________ Amount _______ And we have table like this Number Name amount 98 99 100 101 when you enter 101 in user from tall data will insert in the 101 corespondent row. Is this possible...

That is not what i am looking for what i want is when i put every thing in user form one will copy to 1st sheet where ever i wated and other copy will save as a DATABASE ON OHER SHEET

Is it possible from user form to record data to two different sheets at same time.