I av a problem trying to create a macro that the selection made in a listbox(List1) to be displayed in a textbox(Text1). here is the code that i did so far...

I have other users, using an excel spreadsheet that I have created, but when they first open this spreadsheet I want a message box / Form to appear straight...

Hi, i'm having dificulties to make a formula that does what i want, and the formula must do like this: A B C 1 Ivone 111 ...

I created an .xl file with multiple sheets once. I made changes to it and merged the two. Now when I open the file a pop-up says this is linked to another...

i have been attempting to use goal seek to solve for a series of data which are discounted cash flows. i have been told that goal seek does not work for non...

Hello Guys: Does anybody knows if there is a way to save automatically when you exit an excel worksheet without having to acknowledge the Save...

I have recovered over 1000 excel and word files from a disk I formatted by mistake, now I have to go through each one to see if I want to keep it or delete it...

I get excel files sent to me by somebody running excel 2000. The file I get from them might be just a very simple, 12 row spreadsheet with no formulas, yet it...

Is there a way that when a cell is selected that it turns a different color, but goes back to the first color after it is de-selected? What properties would...

Hi peeps. Im trying to give a cell a score, depending on a criteria. Basically If cell D4=2 and cell E4=0 and C4=A then make the answer 5 If D4=2 and E4=0...

I have several hundred files on my old (windows 98se) Pc created with lotus 123. Unfortunately, my new pc already has excel 2002 installed. i've spent 4 days...

I'm sure there is a simply fix but I don't know what it is. My formula reads: =SUM(B4:W4)/SUM(B3:W3). If I have no values entered within the specified range I...

Please let me know, how to prepare a project delivery and installation schedule in excel 97

Thanks to Ron and AlfD, I have my new spreadsheet half done. This will make it complete, although I won't matter a huge amount if no one can work it out. I...

I am trying to obtain a sum for rows where two conditions are true. Col B has the part number Col C has the customer number Col D has payment received. I...

I have recorded, then modified, the following macro, which unprotects the sheet, aks if you are sure you want to delete the row, deletes the current row,...

OK. Dave, it didn't work. But at least I know why. Changing the language input method isn't an Excel function; it's a Windows function. Although it is possible...

Try using find/replace for alt 0160 with nothing or look here for the trimall macro http://www.mvps.org/dmcritchie/excel/join.htm#trimall -- Don...

Gotta be a better way but this seems to work. I'm sure it can be improved. Sub ParseBold() On Error Resume Next For Each c In Selection c.Activate For i = 1...

I have a column which shows a format of hours, mins and seconds and would like to find a formula which can convert it into minutes only. i.e...