| Thread | Last Post | Replies |
|
| Multi-column combobox - allow text to span columns? | 01 Sep 2007 00:37 GMT | 1 |
I am creating a multi-column combo-box...that I want to basically mimic the Item combobox in Quickbooks (if anyone is familiar with that). The combobox should look as below, where the "category" is column 1,
|
| Using a "SHELL" Command | 31 Aug 2007 23:49 GMT | 10 |
I'm getting an error message that implies that I can't call a procedure on my system: "This error can also occur if an attempt is made to call a procedure that isn't valid on the current platform."
|
| HPageBreak and crazy error (Excel 97) | 31 Aug 2007 22:58 GMT | 1 |
I have the following line of code that produces something I have never seen before: lngHorizBreaks = Worksheets(1).HPageBreaks.Count When this code executes, it changes the column widths of in the
|
| How can I display a warning if calculations indicate original data may be wrong? | 31 Aug 2007 22:50 GMT | 2 |
Here is my problem. I need to compare calculated data, and my spreadsheet program will be used by unskilled people. There are multiple sets of 3 columns each for input of numbers. The action I describe below will take place with the input of as many as
|
| Column Widths | 31 Aug 2007 22:02 GMT | 3 |
Is there a way I can set columns ... A D H
|
| Sending Email via VBA | 31 Aug 2007 21:46 GMT | 2 |
I'm sending an email using VBA via the code listed below. Everything works fine, but I'd like to incorporate a hyperlink in the body of the email, which I don't know how to do. Right now the link (text) is in the body of the email, but i do not know how to make it a hyperlink. ...
|
| Macro syntax problem - Dean | 31 Aug 2007 21:33 GMT | 10 |
I have the following formula in EXCEL (it works) =H78*PerfPercent*ScalingFactor*C78/SUMIF(F55:F77,"=y",C55:C77) which I want to have visual basic type into the current cell. Here is my attempt at writing it in VBA but I am getting a compile error
|
| Accounting Software Import | 31 Aug 2007 21:22 GMT | 2 |
I have a problem that I am finding complex. Basically, I import numbers from an accounting program that has accounting codes, budget totals and amount spent, and remaining cash flows for each accounting code. these numbers arranged in columns with the smallest code at the
|
| Mass File Column Insert and Name | 31 Aug 2007 21:00 GMT | 1 |
I need to create a procedure that will loop through all files in a specified path, insert a new column in each file called FileName, then write the actual file name for that file into the column all the way down the list. How can I accomplish this?
|
| Resize the radio button | 31 Aug 2007 20:54 GMT | 2 |
Is there any way to make the radio button bigger? Thanks!
|
| cleaning up text macro by Alan Barasch | 31 Aug 2007 20:21 GMT | 2 |
I downloaded from the web at the following site http://www.xl.barasch.com/ACl12117.htm code (except for a change I made in the dim statement becasue Mr. Barasch made an honest mistake by confusing RowCount and CountRow and
|
| User-defined Function With Varible Number of Inputs | 31 Aug 2007 20:05 GMT | 1 |
I am trying to create a VBA function that will take a variable number of inputs. Is there a way to declare a variable number of inputs for a function? I have found that if I don't use the total number of inputs declared, I will get #Value. My thought is that a loop could
|
| If Then and Copy/Paste | 31 Aug 2007 19:38 GMT | 4 |
Good morning, I am really new at programming in excel -- I've recorded a few macros, but now I am needing functionality that is going to require me to program something. I was hoping to find some help...
|
| Problem with Error Handler routing? | 31 Aug 2007 19:18 GMT | 4 |
I have a userform in Excel that requires a user to select an option from a drop down combobox. A command button returns the value and opens up another workbook for the user to edit. I added an error handling routine that returns an error message if for some reason the file ...
|
| Finding unique entries in a column | 31 Aug 2007 19:14 GMT | 6 |
I have a range of cell entries, Worksheets(Sheet1Name).Range(Cells(Sheet1FirstRowNum, _ Sheet1RespCodeColPointer) & ":" & Cells(Sheet1LastRowNum, _ Sheet1RespCodeColPointer))
|