Programming

Identify what Combobox was changed to update the correct item on t
hi what code calls userform(5)? code in combo box? if so then you might be able to use a little trick i have use in the past. put a small text box on the main form, hidden so that the user can't see it. then have the combo box code put it's id number in the hidden text box. the code in commandbutton1 can then do a... 21 Jul 2008 23:22

Huge Number of Formulas
Is TOOLS>OPTIONS>CALCULATIONS Set to AUTOMATIC ? "ZipCurs" <ZipCurs(a)discussions.microsoft.com> wrote in message news:EE7D0BA2-5D09-4C9D-BDAD-0C59742282CE(a)microsoft.com... I am working in Excel 2007, although I don't think the problem is specific to this. I have a workbook with about a 100 worksheets and... 21 Jul 2008 22:20

Identify what Combobox was changed to update the correct item on the previous Form
I am trying to identify a particular Combobox on a form. There is 21 in total(cmb23-43) If a particular value is selected fromt he combobox, then another userform(5) is shown. The user then inputs a numeical value and click OK. Using the commandbutton to OK, i need to identify what combobox triggered the... 21 Jul 2008 22:20

Excel 2007 Solver Addin Error 400
Hi I'm wondering if anyone else has noticed the following : On loading MS excel 2007, when I go to the data tab, I get a VBA prompt that reads error 400. Apparently the solver add in is missing. So I go back, trace the add in link, and presto it works fine. Now I close out excel, reopen it, only to find the same p... 23 Jul 2008 11:14

setfocus
On a userform how do I control where the curser goes when the enter key is pressed? Thanks ... 21 Jul 2008 22:20

Run-time error `91': Object variable . . . not set
Any idea what this error means? It occurs at the following line in my code in subroutine "CreateWPMchart"" ActiveChart.SeriesCollection(3).Select I am running the subroutine FixAndCreateCharts() on a CSV file. The most relevant code may be found below. Thanks, Alan Sub FixAndCreateCharts() Acti... 22 Jul 2008 14:45

PivotTables AddDataField
I'm trying to add a pivot table field using VB Office Tools (I have VB 2007 and Office 2007). In VBA, the command is ActiveSheet.PivotTables("PivotTable1").AddDataField ActiveSheet.PivotTables("PivotTable1").PivotFields("r3 Ret"), "r3 Ret ", xlAverage In VB, I can't figure out the equivalent constant for 'xlAve... 22 Jul 2008 15:47

How do I add additional cities to this drop down?
I have a drop down and can not find a sub script that allows me to add additional entries into it. what would I be looking for? I thought I had opened all macros including the form that the drop down is in. A swift kick here might help! using Excel 2000. working a program that I didnt write just trying to updat... 22 Jul 2008 13:43

Reference Label from TextBox
I am using a class I found here that works very well for my needs. Now I would like to reference and change the caption of a label of the same name (number) as the text box. The Class: Public WithEvents txtBox As MSForms.TextBox, CtlNum As String Public laBl As String Private Sub Class_Terminate() Set ... 21 Jul 2008 20:17

Reference Label from TextBox
I am using a class I found here that works very well for my needs. Now I would like to reference and change the caption of a label of the same name (number) as the text box. The Class: Public WithEvents txtBox As MSForms.TextBox, CtlNum As String Public laBl As String Private Sub Class_Terminate() Set ... 21 Jul 2008 20:17