Ok guys, I've come to you with another annoying (for me anyway!) Excel VBA combo box problem. First of all, this is just something I am doing for fun, I have no professional programming exper...
I have a spreadsheet which has a DateReq column.
When I click in a cell in that column, I want a calendar to pop up, and when I've selected the date, I want it to populate that cell (and th...
Experts,
I want to understand how to use a radio button in Excel/VBA.
I want it so that if I select a radio button the contents of a cell changes according to the code. For example from ...
Am I hallucinating or did they remove any or all options in 2007 in regards to CSV files? I'm trying to export a worksheet to csv with the normal settings, but I need each field to be enclose...
I asked the same question earlier, but perhaps this question belongs in this section.
I am writing a small piece of VB code for Excel to prompt the user to open the file he needs to work w...
Let's say I have an excel spreadsheet with 3 columns. The first is a ticker, and the second two are data values that pertain to each ticker.
For example,
MSFT 1.5 .12
ADBE 2.0 .1...
We use office 2000 and 2003. I would like to know how to have excel open in a new window. Right now I open by clicking on an icon. If I open another excel file it opens in the same window. I w...
I'm new to this forum and this is my 1st time to use VBA....
I've looked thru the forum and I found that the someone has answered similar question before but it only has the code posted . So ...
In Excel VBA, I want to allow users a Browse button to go to a folder where a destination report will be sent. Sometimes this will be an empty folder. When using the following browse:
varF...
Hi!
I installed Office 2003 SP3 on many PCs of my company.
When I launch Excel, the error "System Error &H80004005 (-2147467259). Unspecified Error" appears.
To close the error form I need ...
I have a spreadsheet that we download once a year from a source and then we go through and color code the sheet. I would like to develop code that based on a value in a cell at the end of the...
MS Excel Workbook. Using a Command Button, I want to hide columns and rows based on a cell value. For example, Columns A thru D have these values: A1=1, B2=1, C1=0, D1=1; Rows 1 thru 4: R...
We have a couple workstations that seem to have different workbook defaults than others. How can I reset these machines so that when a new workbook is created, it is using the original defaul...
Hi experts,
I'm trying to export data from a Excel sheet to a CSV format. I'm using the "save as type CSV" menu option. The output I'm getting is delimited fields by semicolon (";"), instea...
Experts,
In the attached workbook (EE-FROM_DATABASE-03-2008_NB.xls) I have a data import from a database on worksheet (DATA). What I want to do is create some code in VBA to copy most cells...
I need to do a vlookup like function from within an Excel VBA procedure.
I am building the value to lookup from within the procedure, after that I simply want to do lookup on range, using t...
I have an Excel document that gives the following errors message on any computer (Office 2002/2003):
"not enough system resources to display completely"
This is a very large document and I...
I have a range of cells in and Excel 2007 workbook. I would like to use a drop-down list to select from the range but have the ability to edit the value once selected. For example, I may sel...
What is the syntax to sum a range?
For example
Sum Worksheets("test").Range("A1:D1")
Hi
I am trying to count the distinct occurances of a variable (in this case a date) from a colum in excel.
I have a data string in column A consisting of dates (1st - 31st May) but they ...
A user in our office is analyzing a large set of data with MS Excel. When graphing the data, the user applies a 6th order polynomial trendline. The trendline has this equation:
y = -1E-12...
I am consistently getting a "Cannot empty clipboard" error in Excel 2007 after a drag and drop. Copy and paste does not produce the error. The same error ocurs using Excel 2007 on both my Vi...
Hi:
I have lots of csv files that I need to view through Excel. Sometimes it works fine, sometimes I am given a Text Import Wizard to specified delimiter before the file can be displayed co...
Hi,
If I have two numbers (in dollars):
2005 Spend 2004 Spend
5000 2500
and I want to find what the percentage increase from 2004 to 2005 was, how do I ...
