• Replacing this ListBox code with Treeview code in VBA

    I am importing the Board file and loading the data into treeview directly(Busname as parent node and NetName as Child node with delimitor as ! and i have taken the (myArray(i), "!")(1)) as Bus name and (myArray(i), "!")(2)) as Netname. Simultaniously i am tracking the Duplicate Netnames Listedin a...

    Maheshvba5 pointsBadges:
  • Microsoft Word 2003 VBA Endnotes

    I have a report that I am creating in MS Word 2003 VBA. I need to place some text at the bottom of each section in a Footnote or Endnote. The report is not behaving and the Word Help is not helping, does anyone know a good site to explain how to use and give examples of using Endnotes and Footnotes?

    Flyght55 pointsBadges:
  • Microsoft Access: Hiding form fields with Null values

    Hello, I have a table that has Name F1 F2 F3 F4 Wes x Bob x x Mark x x and so on. Certain names have a check mark "x" and others do not. I need to be able to pull up someones name and see a summary of what they have "x"'s in. I created a Columnar form that has each name as a seperate sheet; listing...

    Wesleycrozier30 pointsBadges:
  • 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...

    Yosiniro5 pointsBadges:
  • Microsoft Excel to VBA

    We are working on a spreadsheet that we need to run with VBA. I need a field to hold "". when running it in VBA it gives me 4 to 8 "". How do I get it to just give me 2 ""?

    Chilipepperz35 pointsBadges:
  • ComboBox in Microsoft Excel VBA

    HOW TO RUN A MACRO WHEN SAME VALUE IS SELECTED IN THE COMBO BOX IN EXCEL VB?

    Narmadha5 pointsBadges:
  • Picking values in the intersection of row and column values

    In row 1(column 2-column11) i have location"<NAMES>"(all different) and in cloumn1 i have customer codes, and the values at an intersection of particular customer code & location are hard coded. I m giving the picking values for customer codes and locations from user defined data. The problem...

    Gahlan5 pointsBadges:
  • Paste values over a formula on condition of a column in same sheet

    Hi, I need to create a macro for my spreadsheet. I will try to attach a sample of it if required and if someone can tell me how to do it. This may aid my description of what I want to do. Basically I need to run a check which does the following: If J2 = ā€œXā€ ā€“ then select F2 and paste special...

    Cmb8010 pointsBadges:
  • Microsoft Excel subtraction using VBA

    I would like to have some coding in vb related to subtraction in Excel sheet.I have 2 sheets.I need to take data from 2 cells from the first sheet and perform subtraction and then placeresult in sheet2.I have huge amount of data in sheet1.I need to perform this operation with all the cells in...

    Devisri20 pointsBadges:
  • Macro toolbar buttons

    what format are they and how do i use them

    Bumblbee10 pointsBadges:
  • VBA – selecting middle portion of a string

    I'm having trouble pulling the middle portion out of a dynamic string. Ex: Orginal String 1 = John Doe, Age 35 (asd) Original String 2 = Tom Thompson, Age 100 (jkl) I need the code to produce... New String 1 = 35 New String 2 = 100 I've tried to research this, but am new to VBA and a lot of what...

    McNitro255 pointsBadges:
  • Convert numbers to text with VBA (ie 10 to be Ten)

    I want to conver number to word ie. if 10 it to be Ten, if 540 it to be five hundred forty so on

    AnandaDebnath280 pointsBadges:
  • Visual Basic code

    how to copy data to another sheet using visual basic

    Geekhead5 pointsBadges:
  • Excel 2003 Help: How to delete duplicates from specific colums and criteria

    Hi I have already sent my question here: http://www.vbforums.com/showthread.php?p=3477514#post3477514 But I will ask the same again: In my Excel file I have several columns and lots of rows. I want the macro to check the column named REF (let say it's in the B column). And it will check if other...

    Groom5 pointsBadges:
  • Search Excel Macro Help!

    I do not know scripting and i really wish i did, any help would be greatly appreciated!I have an excel document that I need to search through for a list of words, when of the words from my list is found, i need the word it found to be put into a new column.

    Abrkadabragimmeahandle5 pointsBadges:
  • Need Help With Multiple Conditions and Constraints for Access 2007 VBA Event

    Hi, Iā€™m working with VBA for On Click Event procedures in Access 2007. My knowledge of Visual Basic is rudimentary and I've come against a business rule I can't even begin to figure out how to code. I work at a college and was asked to build a database for a student conference we're hosting. One...

    Dataempress115 pointsBadges:
  • How to update data using Microsoft Excel VBA?

    I HAVE A CELL "A1=NUMERIC VALUE" & "A2=NAME OF PARTY" WHICH IS UPDATED EVERY MONTH AND I WANT TO SAVE IT WITH "DATA" SHEET WITH EACH PARTY NAME(CELL A2) AND ITS MONTHWISE VALUE(CELL A2).HOW CREATE DATA SHEET WITH MONTHLY COLOUM NAME I.E : DATA SHEET: NAME OF PARTY APRIL08 MAY08 SURENDRA KUMAR...

    Sa2915340 pointsBadges:
  • Outlook 2003: trim leading spaces from email subject with VBA macro

    Hello, some email clients send emails with an extra leading space added to the subject. As a result message sorting on subject in outlook 2003 does not work correctly: these messages are considered to have a different subject and so the entire conversation is split in two seperate conversations,...

    Slay40 pointsBadges:
  • SpinButton linking to an occupied cell

    Can a spin button be linked to the cell that it is located in? I have about 100 spin buttons that I need in this sheet and don't want to individually link each one! Thanks!

    Sleibbra245 pointsBadges:
  • Visual Basic If Then Statement

    HELP! I normally don't write code or develop databases but I am trying to build a MS access database. I have one table (departments) with a list of departments and one table (112) with department, question text and question answer columns. I am trying to build a form where user selects department...

    Williams77710 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following