vba loop help
i am trying to run a simple loop, paste code. i am new to excel vba and am trying to teach myself. here is what i want to do, take the numbers one through ten and paste them one at a time into x. it looks like this. 1 x 2 3 4 5 6 [...]
Answer Question
| February 19, 2010 4:14 PM
Excel 2003, Excel VBA, Microsoft Excel, VBA
i am trying to run a simple loop, paste code. i am new to excel vba and am trying to teach myself. here is what i want to do, take the numbers one through ten and paste them one at a time into x. it looks like this. 1 x 2 3 4 5 6 [...]
Answer Question
| February 19, 2010 4:14 PM
Excel 2003, Excel VBA, Microsoft Excel, VBA
How can I use mscal.ocx on a Windows 7 64-bit machine?
Hi there, I have some VBA code that works in Excel 2003. It references the calendar in mscal.ocx. Typically, when I’ve moved it to a new machine (XP, 32-bit), I’ve had to copy mscal.ocx there and run regsvr32 mscal.ocx and then everything works. But on a new, 64-bit windows 7 machine, with Excel 2003 on [...]
Answer Question
| April 19, 2013 3:16 PM
Excel 2003, Visual Basic Script, Windows 7, Windows 7 64-bit
Hi there, I have some VBA code that works in Excel 2003. It references the calendar in mscal.ocx. Typically, when I’ve moved it to a new machine (XP, 32-bit), I’ve had to copy mscal.ocx there and run regsvr32 mscal.ocx and then everything works. But on a new, 64-bit windows 7 machine, with Excel 2003 on [...]
Answer Question
| April 19, 2013 3:16 PM
Excel 2003, Visual Basic Script, Windows 7, Windows 7 64-bit
Inputing greek symbol in concatenated text
I am trying to concatenate the contents of several cells (which contain alpha numeric data) into a text statement and and also concatenate the Greek letter “mu” representing micro to the end of the statement. When I do this it appears as m. It seems as if I need to be able to specify a symbol [...]
Answer Question
| January 14, 2010 2:58 AM
Excel 2003, Microsoft Excel, Windows XP Professional
I am trying to concatenate the contents of several cells (which contain alpha numeric data) into a text statement and and also concatenate the Greek letter “mu” representing micro to the end of the statement. When I do this it appears as m. It seems as if I need to be able to specify a symbol [...]
Answer Question
| January 14, 2010 2:58 AM
Excel 2003, Microsoft Excel, Windows XP Professional
Trouble with Unload statement in VBA
What am I missing? I have written code with an Unload Userform statement that doesn’t seem to wipe out the Userform from memory. For Ex: (Default: CheckBox1.Value = False) MyForm.Show CheckBox1.Value = True Unload MyForm MyForm.Show So, the form is shown to the user, and they mark CheckBox1 so the value now equals True. The form [...]
Answer Question
| September 17, 2009 7:47 PM
default settings, Excel 2003, unload statement, userforms, VBA
What am I missing? I have written code with an Unload Userform statement that doesn’t seem to wipe out the Userform from memory. For Ex: (Default: CheckBox1.Value = False) MyForm.Show CheckBox1.Value = True Unload MyForm MyForm.Show So, the form is shown to the user, and they mark CheckBox1 so the value now equals True. The form [...]
Answer Question
| September 17, 2009 7:47 PM
default settings, Excel 2003, unload statement, userforms, VBA
Issue viewing “additional controls” for toolbox in VBE
I am unable to view the dialogue box when I select the “additional controls” option from the VBE menu bar, or when right clicking on the toolbox itself. The project I created on one computer includes several forms, one of which includes a few DTPicker(s). Some internal office issues have forced me to work on [...]
Answer Question
| September 17, 2009 5:48 PM
ActiveX Controls, Additional Controls, Excel 2003, library, References, Runtime Errors, Toolbox, VBA, VBE
I am unable to view the dialogue box when I select the “additional controls” option from the VBE menu bar, or when right clicking on the toolbox itself. The project I created on one computer includes several forms, one of which includes a few DTPicker(s). Some internal office issues have forced me to work on [...]
Answer Question
| September 17, 2009 5:48 PM
ActiveX Controls, Additional Controls, Excel 2003, library, References, Runtime Errors, Toolbox, VBA, VBE
Outlook 2003: Export PST Emails To Excel
When I use the “File > Import & Export” command from Outlook 2003, I have mixed results. I keep my emails in sub-folders off one of several PST files that I use regularly, in the “All Mail Folders” side-panel. I broke up the larger folders into smaller ones in case there was a size limitation. [...]
Answer Question
| November 30, 2009 11:34 PM
.PST files, Excel 2003, Export PST, Microsoft Excel, Outlook 2003, Windows XP, Windows XP Professional, Windows XP Professional SP2
When I use the “File > Import & Export” command from Outlook 2003, I have mixed results. I keep my emails in sub-folders off one of several PST files that I use regularly, in the “All Mail Folders” side-panel. I broke up the larger folders into smaller ones in case there was a size limitation. [...]
Answer Question
| November 30, 2009 11:34 PM
.PST files, Excel 2003, Export PST, Microsoft Excel, Outlook 2003, Windows XP, Windows XP Professional, Windows XP Professional SP2
Working with Login Userforms
I’ve been doing research on Login Userforms and have come up with a code variation similar to coding trend. However, I am having an issue clearing the previous information, allowing the user to reenter their password before the loop continues. (i.e. the user inputs “password”, receives an invalid password message, then reenters their password.) As the code [...]
Answer Question
| August 21, 2009 8:52 PM
Excel 2003, Microsoft Excel, VBA
I’ve been doing research on Login Userforms and have come up with a code variation similar to coding trend. However, I am having an issue clearing the previous information, allowing the user to reenter their password before the loop continues. (i.e. the user inputs “password”, receives an invalid password message, then reenters their password.) As the code [...]
Answer Question
| August 21, 2009 8:52 PM
Excel 2003, Microsoft Excel, VBA
Storing a ComboBox selection as a variable
I have written a reporting procedure with various company code variables representing full company names. Different reports will be generated according to the company code that is plugged into the procedure. I am trying to create a ComboBox that allows the user to select the company code, which will then be used as the variable [...]
Answer Question
| September 16, 2009 9:18 PM
ComboBox, Excel 2003, VBA
I have written a reporting procedure with various company code variables representing full company names. Different reports will be generated according to the company code that is plugged into the procedure. I am trying to create a ComboBox that allows the user to select the company code, which will then be used as the variable [...]
Answer Question
| September 16, 2009 9:18 PM
ComboBox, Excel 2003, VBA
EXCEL 2003 and VLOOKUP help in calculating percentage in third cell
Hi all, I have three cells in an Excel 2003 worksheet. Cell one is a drop down list containing: 01/07/2009 – 30/06/2010 01/01/2009 – 31/12/2009 Cell 2 is a dollar amount which is manually entered Cell 3 will calculate a dollar percentage of Cell 2 dependant on which date range is chosen in Cell 1 [...]
Answer Question
| March 22, 2010 3:31 AM
excel, Excel 2003, Percentage, VLOOKUP, VLOOKUP function
Hi all, I have three cells in an Excel 2003 worksheet. Cell one is a drop down list containing: 01/07/2009 – 30/06/2010 01/01/2009 – 31/12/2009 Cell 2 is a dollar amount which is manually entered Cell 3 will calculate a dollar percentage of Cell 2 dependant on which date range is chosen in Cell 1 [...]
Answer Question
| March 22, 2010 3:31 AM
excel, Excel 2003, Percentage, VLOOKUP, VLOOKUP function
Global Search Parameter – Microsoft Query
I have a microsoft query setup in excel 2003 using parameters where the user inputs a departure airport and then a destination airport to retrieve various sales data. However I want to be able to leave the departure parameter blank so that on occasions the user can retreive ALL departure aiports that have a destination [...]
Answer Question
| August 10, 2009 12:02 PM
Excel 2003, Microsoft Query, Query Parameters
I have a microsoft query setup in excel 2003 using parameters where the user inputs a departure airport and then a destination airport to retrieve various sales data. However I want to be able to leave the departure parameter blank so that on occasions the user can retreive ALL departure aiports that have a destination [...]
Answer Question
| August 10, 2009 12:02 PM
Excel 2003, Microsoft Query, Query Parameters
Copy Data from an entire row in Excel 2003 Sheet to another sheet in the same workbook automatically
I have an excel workbook that has a Year To Date summary in it. People enter new data into the YTD summary (along a row there are 15 columns of data to be entered). One of the criteria for the entries is report date. I would like to have other sheets in this workbook (Each [...]
Answer Question
| March 22, 2012 5:43 PM
Excel 2003, Excel formulas, Excel worksheets, Microsoft Excel
I have an excel workbook that has a Year To Date summary in it. People enter new data into the YTD summary (along a row there are 15 columns of data to be entered). One of the criteria for the entries is report date. I would like to have other sheets in this workbook (Each [...]
Answer Question
| March 22, 2012 5:43 PM
Excel 2003, Excel formulas, Excel worksheets, Microsoft Excel
Excel to Access conversion
Accounting came and asked me if a very complicated Excel spreadsheet that they are using for cash receipts could be “moved” into Access. I explained to them the difference between a spreadsheet and a database and that Access could definitely be used to better handle transactions etc. but it would not merely be a matter [...]
Answer Question
| August 12, 2009 3:20 PM
Data transfer, Excel 2003, Excel to Access Conversion, Microsoft Access, Microsoft Excel
Accounting came and asked me if a very complicated Excel spreadsheet that they are using for cash receipts could be “moved” into Access. I explained to them the difference between a spreadsheet and a database and that Access could definitely be used to better handle transactions etc. but it would not merely be a matter [...]
Answer Question
| August 12, 2009 3:20 PM
Data transfer, Excel 2003, Excel to Access Conversion, Microsoft Access, Microsoft Excel
Object Library Error
I keep getting this error when exporting Crystal Reports Ver. 10.0 to MS Excel 2003: Object Library invalid or contains references to object definitions that could not be found. Can this be fixed?
Answer Question
| May 15, 2009 3:50 PM
Crystal Reports, Crystal Reports 10, Crystal Reports error messages, Crystal Reports Export, Excel 2003, Microsoft Excel
I keep getting this error when exporting Crystal Reports Ver. 10.0 to MS Excel 2003: Object Library invalid or contains references to object definitions that could not be found. Can this be fixed?
Answer Question
| May 15, 2009 3:50 PM
Crystal Reports, Crystal Reports 10, Crystal Reports error messages, Crystal Reports Export, Excel 2003, Microsoft Excel
Link Outlook Calendar to Excel Spreadsheet
Hello I am new here and this is my first post. I am wondering whether is possible to link Outlook 2003 Calendar to a spreadsheet in the same way as you would link 2 spreadsheets. For instance if a new entry is created in the Calendar the spreadsheet would be updated automatically. So far the [...]
Answer Question
| April 28, 2009 11:04 AM
Excel 2003, Exchange 2003, Microsoft Excel 2003, Microsoft Outlook 2003, Outlook, Outlook 2003, Outlook 2003 calendar, VBA, Visual Basic for Applications
Hello I am new here and this is my first post. I am wondering whether is possible to link Outlook 2003 Calendar to a spreadsheet in the same way as you would link 2 spreadsheets. For instance if a new entry is created in the Calendar the spreadsheet would be updated automatically. So far the [...]
Answer Question
| April 28, 2009 11:04 AM
Excel 2003, Exchange 2003, Microsoft Excel 2003, Microsoft Outlook 2003, Outlook, Outlook 2003, Outlook 2003 calendar, VBA, Visual Basic for Applications
VBA How to get cpu usages and updated in every one hour,in with in the system.
How to get cpu usages and updated in every one hour,in with in the system.
Answer Question
| April 24, 2009 4:45 AM
Excel 2003, VBA, VBA EXCEL 2003
How to get cpu usages and updated in every one hour,in with in the system.
Answer Question
| April 24, 2009 4:45 AM
Excel 2003, VBA, VBA EXCEL 2003
VBA EXCEL 2003 table coding
Trying to write VBA code taking daily averages from datalogger (144 values/day). Its placing the averages every 144 lines apart in excel sheet. Looking for coding to condense averages into table.
Answer Question
| April 16, 2009 9:13 PM
Excel 2003, Excel Tables, Microsoft Excel, VBA
Trying to write VBA code taking daily averages from datalogger (144 values/day). Its placing the averages every 144 lines apart in excel sheet. Looking for coding to condense averages into table.
Answer Question
| April 16, 2009 9:13 PM
Excel 2003, Excel Tables, Microsoft Excel, VBA
Horizontal to vertical
how do you change a horizontal excel 2003 spreadsheet with qty breaks to a vertical speadsheet with quantitiy break or is there a marco
Answer Question
| April 13, 2009 8:09 PM
Excel 2003, Excel 2003 macros, Excel macros, Microsoft Excel
how do you change a horizontal excel 2003 spreadsheet with qty breaks to a vertical speadsheet with quantitiy break or is there a marco
Answer Question
| April 13, 2009 8:09 PM
Excel 2003, Excel 2003 macros, Excel macros, Microsoft Excel
EXCEL 2003 – CONDITIONAL FORMATTING
Hi, I am working with a tracking schedule for my job, and I am trying to impliment conidtional formatting into it, but some of it it just not working for me. I am working with Microsoft Excel 2003 and I was wondering if you could help me with my problem. Column L = Start Date [...]
Answer Question
| March 1, 2010 2:40 PM
Excel 2003, Microsoft Excel
Hi, I am working with a tracking schedule for my job, and I am trying to impliment conidtional formatting into it, but some of it it just not working for me. I am working with Microsoft Excel 2003 and I was wondering if you could help me with my problem. Column L = Start Date [...]
Answer Question
| March 1, 2010 2:40 PM
Excel 2003, Microsoft Excel
Print one row on all pages in Excel
Hi, Does anyone know of a way to print one row on all pages in Excel, kind of like a header? Thanks, Dustin
Answer Question
| April 9, 2009 1:43 PM
Excel 2003, Microsoft Excel
Hi, Does anyone know of a way to print one row on all pages in Excel, kind of like a header? Thanks, Dustin
Answer Question
| April 9, 2009 1:43 PM
Excel 2003, Microsoft Excel
How to Create “Are you sure you want to ….” MsgBox
I am creating a userform at the bottom of which there are various commands including “Save”. When you click on this I ahve written in a series of checks to make sure that all the fields are filled in correctly but after that I want an “Are you sure you want to save” box with [...]
Answer Question
| April 16, 2009 7:10 PM
Excel 2003, Excel macros, Microsoft Excel, VBA
I am creating a userform at the bottom of which there are various commands including “Save”. When you click on this I ahve written in a series of checks to make sure that all the fields are filled in correctly but after that I want an “Are you sure you want to save” box with [...]
Answer Question
| April 16, 2009 7:10 PM
Excel 2003, Excel macros, Microsoft Excel, VBA
