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 ...
I am trying to put together an excel spreadsheet where I enter the local date in one cell and the local time in another. I want to convert to the equivalent zulu date and time automatically. ...
Hello Everybody,
Microsoft Excel crashes every time I close it... I've attached a screen shot of the error signature. I need to find a way to fix this without reinstalling Office or Excel.
...
I've got several controls (buttons, checkbox, drop-down menus etc.) on a sheet which were all working well. At some point in development of the VBA, I started getting the following message and...
I have a excel file containing 16000 records that i want to import into a mysql database. one of the columns contains a description which contains a carrige return or tab.
How can i remove...
Hi,
I'm trying to create a dynamic drop down list in excel.
I have a column of data and I want to make a drop down list from source criteria listed on a separate sheet.
How do I do this...
I have a macro that creates a template sheet within an active workbook. One of the items on this sheet is a command button that I wish to assign a macro.
I have created the command button a...
I am trying to convert a .SAV file (SPSS format) into something usable in Excel without purchasing SPSS. Are there any available conversion programs out there or other approaches one might of...
I have a macro that I created in Microsoft Excel 2000 and it has been running correctly in version 2000 and version 2003 for a last couple of months. However, just last week, if the macro is r...
What is the easiest way to change a color of a cell based on it's contents? Can this be done with a formula?
For instance something like this pseudocode:
If A1 contains 20.1 then
cha...
Experts:
Is there a date difference function that returns the number of years, months, and days? I've been searching for a long time for something that would give me the correct answer.
...
How do I convert a sql server 8 datetime value to excel format so that sorting and calculations can be done with this column on the spreadsheet?
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...
Hi.
I'm using a macro that emulates the "advanced filter" command, so that when a button is pressed, a block of data is filtered, depending on various criteria, which is dynamic (i.e. it can...
Cell A1 has the Date of the Event
How can we get Cell B1 to show how many days are left until the A1 date.
For Example:
A1 B1
3-31-05 13
Thanks...
Occ
hi,
is there a way to programmatically control the sound volume in Windows? Ideally in VBA directly, but perhaps via a shell command if this is easy in DOS. Need command to unmute windows s...
My Excel file couldn't be saved. When I press 'save', it will pop up an error message:"Document Not Saved". My other Excel files are ok.
I have embedded a non-Microsoft OLE object into my Excel worksheet. When I click on the embedded object the text that appears in the formula window is:
=EMBED("TeeChart.TChart.8","")
I'...
I am trying to insert a pivot table using Excel Macros. I thought that I could just record the creation of a pivot table, but when I try to run the macro a "Run-time error '1004'" appears. Doe...
Not sure if this is even possible. To calculate a date difference between two cells in Excel a formula such as this will work:
=DATEDIF(A1,NOW(),"d")
But what if you are calculating for ju...
Good Afternoon
Experts:
I have a Workbook with 3 sheets. This workbook is used to track changes made to a system. The first sheet contains a column called "Type". This type is either a ...
Hi,
I would like to know the maximun size (mb) that an excel file can be.
thanks
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...
Hi, I am working through Microsoft Knowledge Base Article 213772 "How to Use System, User, and File Data Sources"
It describes how to use an Excel VBA Macro to link up (via ODBC) to the MS ...
What is the Excel formula to SUBTRACT a percentage from a gross amount to result in a net amount?
Example:
Gross Price = $106.00
Sales Tax = 6%
What was the original net price before tax?
...
