vba 2003

Hi All, I've been using the following code successfully and this is it's function: It copies some values from one sheet to another, then looks for a value (0,1 or 2) in Column A of the ("Environment Information") worksheet and then copies a specified row from the ("Format Control"). sheet...

Hi, I was looking for some help in coding a search button. I need a single text box in which people can type a name and press go. I then need the data displayed in a user-form. already have the user form as it is the same format as the one I have created for data entry and the data returned...

Hi I am running the following code, trying to check and see if values in a cell have changed everytime the sub runs (through a button on the worksheet. Essentially I am looking up data in another closed excel file called "TODAY" comparing it to data in the new workbook and if there is any...

Hello, I have a macro below that separates currency from a custom format. It works fine but as you can see it only addresses CAN and I need to be able to add additional currency like the ones I have listed below. How can I modify this vba to accomplish this? Need to add: "#,##0" ZAR";-#,##0"...

Hi all, long time reader, first time poster. I've got problem that has me stumped, and would be hugely appreciative of any advice. I use Excel 2003 and Windows XP. The problem is as follows... I receive data, containing addresses (Up to 100,000 in some cases). Each country needs to be...

I was wondering if anyone can tell me why the following code works fine in Excel 2003 but not in Excel 2010. Here is the code: <TABLE style="WIDTH: 288pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=384 x:str><COLGROUP><COL style="WIDTH: 48pt" span=6...

Hi to all I'm a new user. I have a trouble, I have to create a polar chart on excel. To do this I create a VBA subroutine to simplify its creation (in my mind..). It is a very stupid operation , but probably due to my poorly experience with VBA, I'm not able tio run it! Can any one help me...

Hi! Seasons Greetings! In MS-excel 2003, I have written macros for different actions on a work sheet. For every action I am storing the previous and current values of the affected range in an array for a later undo and/or redo of the macro actions. At the end of every macro that are invoked by...

My experience has been mainly SQL Server. I am working on an Access 2003 database with a simple data entry form (frmNewPatient) for inserting new records into a Patient table. Before executing the insert, I want to check that there is no matching record already in the Patient table. The form has...

Hello, I am using MSExcel 2003 and have recorded a macro that I would like to edit but am coming up short on a good solution. The sub routine will insert columns and convert data from other columns using the UPPER function. I have copied out a portion of the macro below and feel that if I...

I had the code below on a button, but when I press the button nothing happens, I am on sheet 1 of 31 when I press the buton. Any ideas from anyone? Sub NextSheet() Set sh = ActiveSheet On Error Resume Next Do While sh.Next.Visible <> xlSheetVisible...

Hi, I have created a userform and have set it up so the user will add the date by selecting the day on a listbox1, month listbox2 and year listbox3. This seems to work but I think it would look cleaner if I could set the user form to have todays date as default but if this date needs to be...

Hi all, I've created a Form / dialogue box (called Error) in VBA and I want this to display if a cell on my workbook is empty via a macro. I also need it to run another macro if these circumstances are not met. Essentially what I have is: If Range("A1").Value = 0 Then Show Form...

Hello, So I have this macro that filters entered data by quantity. There are hundreds of items, and for selected items I fill in the quantity and price (one is in column E, the other in Column F), and I use the macro to filter what I fill in by quantity, so all I can see is the data I have...

Hi guys, I am using a userform which has a textbox which I have set to multiline so that the user can enter several lines of text all in the same textbox. This text then needs to be copied to a cell in Excel. My problem is that when I do this the carriage return squares appear at the end of...