Experts,
In the attached file please select:
1. Cell CIF!C8 - that will start a macro which shows a UserForm.
2. A company name in the top ListBox. That will display that company's addr...
The attached file is a Sample Size calculator that I downloaded and I'm trying to understand how the formulas work. I'm trying to understand some of the code in the formula on sample size.
...
I have created a column chart in excel 2007 and I am trying to get it so that there is no space between each bar and the one next to it... Maybe called the width of each bar/column. Please s...
Hi, I have a macro that compares the strings (they are all addresses) in two different cells of the same row, and if in one row the first cell has "drive" or "street" or avenue" etc in the add...
I am really asking this for feedback but do have a question or two that I will try to include. I had a CSV file that I imported into Excel to be able to read and review. The data will actual...
I am trying to figure out how to show a cell comment using VBA. The behavior should replicate what happens when you use the Shift+F2 shortcut to show a comment, so that the user can then hit ...
Hi,
i have some code (excel 2003 vb) and the "Application.DisplayAlerts = False" works a treat, however at the very end, just before i display a hyperlink to a windows folder, it stops work...
Hello,
My mini mac has Excel 2008 on it. It won't open any files.
I can paste into a blank spreadsheet, but I can't save anything
I get the following error upon opening a file:
" ...
hi, pahse 3, attached works fine,
At present when taking the relevant row from main data 1 to Calendar it pastes to the next cell avaialble for that date match and if the next cell isnt em...
I have an excel spreadsheet with 3 sheets. On these sheets I have a number of columns but I want to get name and id columns. the id's match on all sheets. I would like to make a master shee...
When I try to save a file in excel from network, it prompts me to save to a different file as there is an access violation. 75ff2000 (Read only or encrypted)
Hi experts,
I have Norton Antivirus Corporate Edition 7.x installed on my machine. Can anyone tell me how to update the virus definitions with the latest virus definition.
Regards
Kanwa...
Hello experts,
I need to compare two files that are pasted in an excel worksheet and create a master file with a superset of the data from both files. I'm guessing that something similar...
Hi Experts,
I have been using the below mentioned code successfully to connect to Attachmate Extra. Using these definions i have been sending keys and extracting information into Attachmate E...
Hi I want to add the input data from an input box into my list box form.
I have a list box form which looks up a range of data A1:A10 which are Customer names.
I have created a button whic...
Hello ;
I want to change the shape colors by selecting shape in code .
as i know this is done by
ActiveSheet.Shapes("YourShape").Fill.ForeColor.RGB = RGB(Red,Green,Blue)
But the names a...
One of my users had 31 macros he used in Excel 2003. All of these disappeared when I ugpraded him today to Excel 2007 when I upgraded the Office suite to 2007. Is there any way to recover th...
I have two sheets in a workbook (Excel 2003).
Sheet1:
A1 A2
A1 Matt FALSE
A2 Matt TRUE
A3 Matt TRUE
A4 Chris ...
I hope I can make enough sense what the question I'm about to ask.
I have a user in Finance who I believe knows what he wants but just does not know how to explain it to me. Anyway this is ...
Hi Guys,
I have a workbook that uses multiple userforms, reports run from these forms display graphs etc. My issue is the userform staying loaded. I need to figure out how to Unload them al...
In the attached file, there is a text box that has a cell reference in it.
What procedure is used to get the formula into the text box like that?
Also, once the cell reference is assigned ...
Sheet tabs are not showing in excel 2007?
Have a worksheet that users create a report (pivot table) from. I setup a Validation list box that shows all the tabs in the workbook like "june", "july", "august".
What im looking to do...
Can I do the same thing in Excel VBA than in the example of c++ code below?
This is called the ternary operator or also conditional assignment.
I know it exists on most languages.
If it d...
On the attached file, I have the following problem: When opening in excel 07, it hangs for a couple minutes, then pops up Unable to open http://.... Cannot download the information you request...
