excel 2003

The following macro is working fine excel 2003...but not working in excel 2007... please help.... thanks in advance.... Public Sub ExcelGoogleSearch1() Dim searchWords As String With Sheets("Google Web") RowCount = 1 Do While .Range("A" & RowCount) <> "" searchWords = .Range("A" &...

Hi, I am trying to use a macro written by someone in my department. It's basic function is to pull up a schematic from another program based on the number in the selected cell (e.g. 167722A). All that should be required on my part is to paste the Add-In in the Office 11/XLSTART folder. The...

Hi all -i'm brand new to this board (though I think i'll be on here quite a bit! :)) I have a problem in excel that i just can't get my head around, i'll try to pose the question as simply as possible as trying to explain why i need this is a bit of a headache!!! Basically, i have a list of...

Hi folks.... I apologise if this has already been answered but I've tried copying other user's 'received answers' but to no avail and I've used up 3 and half hours of my life so far trying this out - I hope you can help. Now I've used this fine, and I get the correct answer from it...

Hi all, i am trying to populate a listbox with all the opened workbooks. But i can't seem to be able to do that. These are my codes Sub test() Dim wb As Workbook Dim myArray() As Variant Dim counter As Variant Load frm_SelectPrompt For Each wb In Application.Workbooks...

Hello, I am trying to make a dynamic chart that will update when I put 2 columns of information in: Portfolio and Benchmark returns. I have everything worked out except one area, and it has to do with a date. I have maybe 100 different portfolio paired returns, so I made one master worksheet...

Hi, I a newbie in VBA coding, but for the purposes of company I work in, I wanted to learn it, to make my life easier. Recently I needed to code a macro gathering certain ranges of data and pasting it to a specific place. My macro looks like: Sub NAVrecap2011_Maciej_Wludyka() ' '...

Hi all, i need a variable for a date which is static, global, and the value of this variable can be changed via a userform. Is that possible?? :| Excel 2003 Shie Boon Thanks

Hi all, I have a userform which starts up at a particular position (at Row 1) whenever a worksheet is loaded, which purpose is to provide better user experience. But because of smaller screen sizes such as the laptop, the userform appears at the top of the screen, covering the buttons. Is...

Hi, I have been given an excel 2007 model but I only have Excel 2003 on my work computer. When I have opened up the model, I got #name in the cells where there is this formula. After doing somer research I learned that SUMPRODUCT formulas should be used. The question is whether SUMPRODUCT...

I'm searching for certain files on a specified, referenced drive in Worksheet("Parameters"). These files have to be last modified before a certain date and the search should not locate certain files in specified, referenced folders. The goal of this project is to collect "stale files," and...

Hi all, May i know how does AcceptAllChanges work in detail? I currently have a shared excel workbook in Sharepoint, and when a user 'checks out' the workbook, the workbook will be 'locked for editing' and the rest would not know who is using the workbook at the moment until they click on the...

Hi all, i accidentally deleted my original file, but i have a backup file of my excel workbook. Currently its filepath is blahblah.xlk. I wish to convert it back to .xls form to prevent any problems. Is that possible? Thanks excel 2003 Shie Boon

Hi all, I have two userforms open at the same time. And i want a particular code of the active userform to First, unload itself. (Code: Unload Userform1) Second, click a button in the second userform. (Userform2) (Code: button1_Click) But an error prompts, "Sub or Function not defined"...

Hi all, i have a procedure which unloads a userform. When this userform is loaded, one of the textboxes are setfocused on (textbox1.setfocus). This textbox has validation codes in its BeforeUpdate event. If wrong text is entered, there will be a prompt. In the procedure i have the...

Hi all, I want to load a userform in the middle of a procedure and only continue the procedure after the userform has been closed. Is that possible? excel 2003 Many thanks, Shie Boon

Hi all, i have a range in a worksheet which i want to copy to another worksheet when i click on a command button, in the same worksheet. Unfortunately, the command button lies within the range. Thus whenever i click the button, the button gets copied over too. How can i prevent the button from...

Hi all, i have a combobox that has a rowsource to a named range. After the user enters a value, or selects a value from the list, i want to check whether the entered value is within the list of values. If not in the list, i want to warn the user. So far i have done up till the warning...

Hi all, I have a database and a few hidden columns and right now i'm using vba to insert new records via a userform. Whenever a new record is inserted via the userform i use codes to draw the borders. However, the hidden columns doesn't have the borders drawn when i unhide the columns. Any...

Hi all, I have a userform, with textboxes within to accept input from users. In the exit events of these textboxes, i do data validation. When the data entered by user is not valid, i prompt a messagebox and set the cancel property of the exit event to true. As i test my application, i...