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...
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...
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...
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...
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....
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....
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...
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...
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...
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...
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...
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...
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...
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...
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....
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....
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...
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...
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?
View Answer
| May 4 2009 3:50 PM GMT
Crystal Reports error messages, Crystal Reports 10, Crystal Reports
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?
View Answer
| May 4 2009 3:50 PM GMTCrystal Reports error messages, Crystal Reports 10, Crystal Reports
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...
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...
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.
How to get cpu usages and updated in every one hour,in with in the system.
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.
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.
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
how do you change a horizontal excel 2003 spreadsheet with qty breaks to a vertical speadsheet with quantitiy break or is there a marco
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...
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...
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
Hi, Does anyone know of a way to print one row on all pages in Excel, kind of like a header? Thanks, Dustin
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...
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...
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...
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...
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?
View Answer
| Apr 6 2009 7:59 AM GMT
Excel 2003, Lotus Notes email attachments, Microsoft Excel 2003
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?
View Answer
| Apr 6 2009 7:59 AM GMTExcel 2003, Lotus Notes email attachments, Microsoft Excel 2003
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...
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...
