• 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:
  • Excel Calendars

    I have a schedule and would like to put the current months calendar as well as next months with cells that I can add info to for each day. Currently someone has to update the dates from month to month. Is there a way to have the calender update by just changing the Month and 1st date?

    Sandman00730 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:
  • 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.

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

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

    Dontgetit105 pointsBadges:
  • vba recorder issue

    When I run excel 2007 and try to record a macro, it will not record any commands for inserting a wordart or editting the text of the wordart if one is already created on the spreadsheet. I am at a loss to determine the right commands without the recorder, and I can't figure out why it will record...

    Lostinspace20005 pointsBadges:
  • 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

    Mike5010 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:
  • What is the Excel VBScript for the following…

    Avatar I put a value in cell B1 and a value in cell C1. Then, when I put a value in A1, I need both B1 and C1 to over-write themselves and become the product of A1*B1 and A1*C1. The same for A2,B2,C2 and A3,B3,C3, etc

    Bebchi15 pointsBadges:
  • 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?

    Wind80720 pointsBadges:
  • Data transfer from EXCEL using AS400 add-in to AS400 physical file

    If EXCEL is the starting point, how can I make the user specify the file name to transfer the EXCEL info to. Or how can I lock a predetermined file until after the transfer is complete? Thanks in advance

    BobK5 pointsBadges:
  • Linking Information in two seperate Workbooks

    I need to create a Workbook that has certain cells accessible for people to enter in thier information and then have the ability to pick from a drop down list that will autopopulate a name beside the job number chosen. I have managed to do this using V lookup however the main source Workbook opens...

    CleanEnergy5 pointsBadges:
  • Puzzle – Find the number?

    This is not a question & I am not sure if this is a proper forum. So I will let the site moderator decide. I recently came across a nice quiz which, I think, supports/encourages developing programming skills. So ... here is the puzzle. Find the lowest number with the following characteristics: When...

    SbElectric2,540 pointsBadges:
  • Data transfer from webpage to excel

    I have a complicated problem for data extract from a web site. It is about a horse race analysis. problem description as below 1. want to retrieve some historical data and non-dynamic 2. datas are spread into many different web pages and they are in asp. 3. pull down menu is on the web page and...

    Hbongsui5 pointsBadges:
  • Reconcile two sets of data without a unique field.

    I have two data sets that have account number and dollars. There are duplicate account numbers and dollars as this is a batch of credits interfacing with another system. I need to reconcile the first set to the second set. So in think it is something like this, if account number and dollar in set...

    Chitown5 pointsBadges:
  • SQL Export to Excel file column?

    I need to create a SSIS Package in which the data is export to Excel file the problem is the date and time column in sql there is one column and i need to separate it into two column can any body help e i thid? thank in advance

    Shamilh10 pointsBadges:
  • Cell Formatting Protection

    How do I protect a cell (or series of cells) from being re-formatted, and yet allow the user to Sort and Copy the Data within the spreadsheet? When I LOCK the cell(s), then protect the Worksheet and contents of locked cell, I allow them to Select Locked Cells, Select Unlocked Cells, Delete Rows,...

    Cdixon20005 pointsBadges:
  • Problems using VLOOKUP

    I have an excel 2003 spreadsheet that contains a Volunteer Worksheet for the purpose of driving clients to doctors offices, and another Transportaion Worksheet that enters the dates and medical facilities to where clients will to be driven. I am utilizing a form, with a drop down list, to find a...

    Ironsprings5 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