Excel 2003 Questions and Answers

Recent IT Questions

1 - 20 of 100
<<PREVIOUS 1|2|3|4|5 NEXT>>

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...

Answer Question   |  Sep 17 2009  7:47 PM GMT
VBA, Excel 2003, default settings
asked by McNitro

  155 pts.

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...

Answer Question   |  Sep 17 2009  5:48 PM GMT
VBE, VBA, Excel 2003
asked by McNitro

  155 pts.

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   |  Aug 20 2009  11:34 PM GMT
Outlook 2003, Excel 2003, Export PST
asked by CaliforniaJerry

  5 pts.

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...

View Answer   |  Aug 18 2009  8:52 PM GMT
VBA, Excel 2003, Microsoft Excel
asked by McNitro

  155 pts.

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...

View Answer   |  Aug 11 2009  9:18 PM GMT
VBA, Excel 2003, ComboBox
asked by McNitro

  155 pts.

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...

View Answer   |  Aug 8 2009  3:31 AM GMT
VLOOKUP, excel, Excel 2003
asked by Ianmax49

  65 pts.

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...

View Answer   |  Aug 5 2009  12:02 AM GMT
Microsoft Query, Excel 2003, Query Parameters
asked by TrueBlue76

  15 pts.

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 named a month, ie....

View Answer   |  Jun 11 2009  5:43 PM GMT
Excel 2003, Excel worksheets, Microsoft Excel
asked by Wiggetssis

  25 pts.

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...

View Answer   |  Jun 9 2009  3:20 PM GMT
Excel 2003, Data transfer, Microsoft Access
asked by KSoniat

  610 pts.

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?

asked by Mzdoreen

  5 pts.

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 way I...

View Answer   |  Apr 28 2009  11:04 AM GMT
Outlook 2003 calendar, Excel 2003, Exchange 2003
asked by Yosiniro

  5 pts.

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.

View Answer   |  Apr 24 2009  4:45 AM GMT
VBA EXCEL 2003, VBA, Excel 2003
asked by Rajuaruna

  70 pts.

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   |  Apr 16 2009  9:13 PM GMT
VBA, Excel 2003, Microsoft Excel
asked by Bellyflop

  5 pts.

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

View Answer   |  Apr 10 2009  8:09 PM GMT
Excel 2003 macros, Microsoft Excel, Excel macros
asked by Mike50

  10 pts.

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 Column W = Due Date...

View Answer   |  Apr 10 2009  2:40 PM GMT
Excel 2003, Microsoft Excel
asked by Kelz827

  40 pts.

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

View Answer   |  Apr 9 2009  1:43 PM GMT
Excel 2003, Microsoft Excel
asked by RoadDust

  390 pts.

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 the options Yes and...

View Answer   |  Apr 7 2009  7:10 PM GMT
Excel 2003, VBA, Excel macros
asked by Dontgetit

  105 pts.

Excel custom format, weekday & date line break query....

I created a spreadsheet which is to act as a rota, with the day and date displayed to the left. I entered the date then went to the custom format tab and entered dddd dd/mm/yyyy so it would display the day and date. So it can be printed with all the relevant data it is nessacery for this data to be...

View Answer   |  Apr 7 2009  4:34 PM GMT
Excel functions, Excel 2003, Excel formulas
asked by Dangerchef

  35 pts.

Excel file problem in Lotus Notes

When the user is trying to open an attachment ms excel 2003 file, the user is not able to open it, but the user is able to open the file after it is saved to the computer/ The user is having problem only witht he excel files.Can anyone please help me with this?

asked by Wind807

  20 pts.

how to assign a numerical value to a word in excel

I want to be able to select a material from a drop down list in column A, then type in the time in Column B and in a third column have the cost appear. What I need is to associate eg. VHS as having a rate card of £30. I can make lists and I can write the simple equation in the cost column to...

View Answer   |  Apr 3 2009  10:57 AM GMT
Excel 2003, Microsoft Excel, Excel macros
asked by Dontgetit

  105 pts.

1 - 20 of 100
<<PREVIOUS 1|2|3|4|5 NEXT>>