vba 2003 help

<tbody> Thanks in advance. I'm trying to call a function using a variable name. It's throwing the below error The macro 'testfunc' cannot be found. Resume without error I tried below 3 statements but all are throwing the same error. <code>sFuncName = "testfunc" ExtractData...

Hi, Hopefully some sharp brains that could help me out.... :-) I have a dynamic drop down list in B3. The dynamic drop down list in B4 is a result of my choice in B3, and my dynamic drop down list B5 is a result of my choice in B4. When changing a value in B3 the drop down lists B4 and B5...

I know it's possible to do a left lookup, I am currently using this formula on the worksheet: =VLOOKUP($B4,CHOOSE({1,2},Sheet1!$C$2:$C$65536,Sheet1!$B$2:$B$65536),2,FALSE) Unfortunately, I cannot use this. This spreadsheet has several userforms to populate my spreadsheet with data. When using...

Hi, The situation that I am facing is that identifiers that are entered into a column are used to search a database and display data in other columns. However, when a number is entered that starts with a zero, excel automatically truncates the number to omit the zeros. I am attempting to use...

I am trying to make a macro that allows a user to select a cell or a range of cells and then paste them to a location that they want. I found some code that allows the user to select a range to paste to and tried to modify it to also copy but to no avail, can anyone help me out. Here is the...

Hello everyone ! :) I'm currently stuck because excel 2003 only has 3 criterias for conditional formatting... and I need about 22?.. :( What I'm trying to do is I'm trying to set for example Apples to be all in colour red and Bananas to be all in Green and Strawberries to be all in Pink and...

I am trying to move items up and down my listbox2 I have the code below however there seems to be an error with the moving down button Option Explicit 'Move ListBox Items code Private Sub BTN_moveselectedLeft_Click() Dim iCtr As Long For iCtr = 0 To Me.ListBox2.ListCount - 1...

Hi, The content of excel is captured as an image with the help on macro. Now i want to create one more macro that will send an email with the captured image as body of the email. (Note: the image should be in body and not an attachment.) Is there a predefined method in VBA? Thanks! Archie

Hi, I have written a code for reading the excel and capturing the content as an image but now i want to paste the captured content into another sheet of the same excel and want to add new column in the same captured image? Can you please let me know if it is possible to add a column in the...

Hi,I want to write a VBA code that will find the third monday every month and will add one sheet in my excel.I have a code that adds a sheet to excel but not able to apply the logic of third monday.For eg: if i run my macro on 20th august. i will check if its 3rd monday and will add one excel...

Hi. My first post but I hope I can get some help from You guys :) I've browsed the forums, but it's just to much for me at this time :/ I'm an intern and my supervisior asked me to do this task - but my experience with coding is meh What I need to do is to get a sting from column x row 1 to...

Hello, I am newbie trying to find how to generate a list base on the differences of another list. let me explain; I have a list of combination A1:F2200 each row of course the numbers have difference, example: <TABLE style="WIDTH: 288pt; BORDER-COLLAPSE: collapse; mso-padding-bottom-alt: 0in...

I am a teacher at Conway in England UK. I have been working on a simple tracking assessment system for my staff. This is a prototype. I have 4 worksheets in a workbook, in Sheet1 on row13 I have the following headings: colA=Unique Identifier, colB=forename, colC=surname, colD=gender, colE=FSM...