Programming

How do I make a golf handicapping form in Excel?
I am in charge of keeping the handicaps in my golf league. How do I make a "master" to do this? ... 20 Apr 2010 21:55

Object Browser
In the Object Browser, the Classes and Members panels display correctly. However, when I select an object or member and click on Help (i.e. the yellow ?), an Excel Developer screen is displayed, not a list of topics associated with the selected object/member. Entering a term in the search box of the Excel Dev... 21 Apr 2010 09:28

Macro Order Rank
Hello, I currently have a workbook with 36 sheets within for a production report. The workbook is set up with a 1 monthy total sheet, 5 week total sheets and 6 days sheets per week. I also have a macro set up on one sheet that will auto rank one (production) column which then would re-arrange the employee's na... 20 Apr 2010 18:34

Using VBA to create PDF - setting paper size
I am successfully using Ron de Bruin's Create and mail PDF files with Excel 2007. Here is the relevant snippet from his function: Myvar.ExportAsFixedFormat _ Type:=xlTypePDF, _ FileName:=Fname, _ Quality:=xlQualityMinimum, _ IncludeDocPro... 28 Apr 2010 17:29

input box prompt
Hi, Once again I need help. I have an Input Box that I would like to set a portion of the prompt font to bold. I've searched the forums and could not find an answer. This is the code for the Input Box that I'm using InputBox("Enter Allocation For : " & .lstProddescp.List(i) & vbCrLf & "Current Qty is : " &... 20 Apr 2010 16:32

Solver in vba
Hello, I have Excel 2007. My Solver works OK. My Solver would not work in VBA mode. All statements that start with Solver are regarded as errors. Peltier advises that Tools/Reference list Solver item should be given a check mark. However no such item as Solver exists on the Reference list. Best Regards, a... 21 Apr 2010 06:22

Converting a number (17 characters) to text (Scientific Notation)
Here's my dilemma and challenge… … This is through Automation… I'm receiving an XML file that has excel formatting… It's very easy to import, the problem comes in when I import large numbers (17 – 20 characters long)… They should be imported as text, but they are importing as numbers, so they appear as sc... 20 Apr 2010 16:32

Charting the Sum of Two, or More, Series of Data
I know there must be a relatively simple solution to my challenge, short of creating a new series od data which is the sum of desired series. Let's say that I have the following 02/13/2010 02/20/2010 02/27/2010 ... 0-30 $7,072,987 $5,990,448 $8,978,002 31-60 177,472 160,460 142,547 61-90 ... 22 Apr 2010 12:26

Find and Then Loop
I'm starting a similar project however this is a "running total" spreadsheet. I will be comparing the data in "myrange" with several different columns that will be added to each week. This week the comparison would be with "D" and "P" next week there will be another column. All columns will have the title "R... 20 Apr 2010 13:26

Need help with Trim function
The following block of code strips away any formatting from copied text before it is pasted. Private Sub Worksheet_Change(ByVal Target As Range) Application.ScreenUpdating = False Dim Temp As Variant Temp = Target.Formula On Error GoTo endit With Application .EnableEvents = False .Undo ... 20 Apr 2010 18:34