Hi experts,
I am trying to use listbox in excel, I populated the listbox with a range.
Now I wanted to make a quick filter on this listbox possible.
For that purpose I created a textbox1
...
Hi,
What is the code to make a negative number (-1) inside a cell display in "red" & "bold" based on the results of an IF function being true or false. Below is my formula which will display...
I have a users with Excel 2003 SP3 and one particular file is a problem. When she double clicks on the file from her desktop, Excel opens, but shows the grey screen. The odd part is, it show...
Good morning, this should be easy. I know it can be done in a Pivot Table, you can format the numbers to be a Percentage of the Whole column, would be easy if our surveys were 100 respondents ...
unable to open a .xlsx file with Excel 2002 or 3 even though the microsoft file converter is downloaded.
i have to make a spreadsheet into a database no big deal, except that
the people who made the spreadsheets set up different worksheets for each employees location.
example they have one wor...
we have an excel sheet in spanish language which needs to be coverted to english....pls advice........attached excel sheet (sheet1.xls) in spanish
Hi,
I have an XLS file.
In column B I have a usernames. I need to be able to look for a word in column b and if it matches highlight the entire row
Also
If I open one of the XLS spread...
Hi Experts.
I have an Array that I got from a Excel Sheet with several elements, some duplicates and many of them being blanks.
How can I delete all dulpicates and all blanks?
Thanks,
Okay, this has got to be easier than it seems to be.
I have a spreadsheet with about 45000 entries. I need the just two columns ... date ... and another text value, which there are about 2...
Dear Experts:
I am using Excel 2003. I got one Excel file with a large range in which each cell has a reference formula like "=Sheet1!AA12".
I now want to copy these formula conten...
We are running some macros on Excel 2000 very fast.
When we have migrated to Excel 2007 it is very slow... even on Excel 2003.
It seams to be related to sub-total .....
Any Ideas on how...
I need to generate a starting S Curve (Timephased at first, then Resource) only given the total number of hours, project task, and duration. I know that the starting S Curve will be just star...
Thanks to EE saurabh726 I can add button to Excel through VB 6 code. I now need to be able to run a macro from that button. I have tried to use the code below, but the macro isn't imported int...
I've got a spreadsheet with developer tool objects (checkboxs and listboxes). In the code for a button click event, I need to find out if the checkbox is checked and I also need to know how t...
Hi All!
Hopefully have an easy one today! Our company has an accounting calendar that differs from the traditional calendar. Not a big surprise! Our weeks always end on a Sunday and begi...
Hello Experts!
I have two Pivot Tables where I am using One Column from each to calculate a Percentage. The Percentage Column should update when the pivots are refreshed and additional rows...
In Firefox and IE7, if you are in a combobox, you can "search as you type". Consider a list
Aardvark
Anteater
Bollywood
Neanderthal
In IE, typing "a" then "n" ends up at "Neanderthal". ...
Hi
I have compiled afile containing macros with Excel 2003. Can anyone tell me how my colleague should proceed when opening the file in Excel 2007. Apparently there is a problem enabling them...
I have an ODBC connection in an Excel 2007 spreadsheet ... This is what it looks like when I click on
Workbook Connections, Properties, Connection Properties Definition, Connection String:
...
I have a spreadsheet that looks like a form for users to fill out. On it are cells that I would like a checkmark or an X to appear when they click on them. They are in different areas of the f...
Hi everyone,
Just a simple question technical question here. In Excel 2002, when I store unique keys/items to the Dictionary object, it stops at 256. Unfortunately I have 268 unique values ...
I have built an Excel form that allows users to enter their details and click the "Send" button to call Ms Outlook, compose an email and send the Excel form to the manager.
I have written ...
How to find a perticular sting & return a value according to the string,
e.g. in a cell data is -
1. Milling Front Side - return value - Milling
2. Milling Back Side - return value - Mill...
hello to the excel expert,
pls advise, if their is away to change format of a cell to look like and to behave like a checkbox?
I can program it with vba.
Thank you,
Yalon
