• Conditional formatting

    How do I get conditional formatting in a form to continue to work as a sub form

    Dbarrett5 pointsBadges:
  • Trying to copy a value created within a subroutine to another cell in the same worksheet

    I have a string of cells that are populated by my macro. what i need to do is: each time the value populates, i need to copy just the value to another cell so i can record the results of the macro for a long string of numbers. heres what i have, this is not working for the last step - Sub Count()...

    Irish44455 pointsBadges:
  • Switching Excel Custom Views Based on Selection

    I have two saved Custom Views for a protected worksheet that I use as an input and summer page for an estimating spreadsheet. I want to include a validated cell on the front page which would select one of these two custom views based on which answer the user selects. Unfortunately I am very limited...

    Brgbldr5 pointsBadges:
  • How to pass value at run time from VB 6 to Access 2000 Query for reporting

    I have developed a sall application. Data is in Access 2002, Development is in VB 6. For reporting I have designed Queries, using the queries I have designed the reports. It works fine. While run time I accepts the criteria or value from user, based on that I have to show reports. My question is...

    Mayuri155 pointsBadges:
  • VBA question for a beginner

    I am very new to VBA and my boss is having work on a spreadsheet that dynamically updates the comment box with a value from a designated cell. Here is what I am using for the first target address of C39 to be displayed in a text box in C5. Problem is I have to do it for 140 cells. I don’t know...

    Gburns1235 pointsBadges:
  • Deleting all formulas in a worksheet when unprotected in VBA code

    I would like to know the vba code for deleting all formulas within a worksheet if the worksheet is unprotected by any one, obviously I would have to have an administrators code in case I need to unprotect the worksheet myself. My workbook contains many worksheets and with many formulas I have...

    Barnoldswick5 pointsBadges:
  • email query recordset

    "I have a query (emailnotifytest) based on 2 tables . One table (shipmentdata) filters on new records. the other table (contact) filters which contains the email address filters whether the address is not null. The tables are joined by the companyname. the code below works as far as sending the...

    Roundy5 pointsBadges:
  • How can i connect DB and input values in stored procedures using VBA

    hi all, i am using a automation tool, which is with VBA scripting. I want to execute the stored procedure by giving the values. guys help me....

    Jprpvk5 pointsBadges:
  • How can we insert space between text and a table in MSword using macros

    My task is like this. SampleText Table1 with some columns and rows. I need to insert text between "SampleText" and "Table1". When I am inserting text it is inserted into the first cell of "Table1",however I have to insert it in between "SampleText" and "Table1" by inserting line break/space between...

    Iamfromhyd20 pointsBadges:
  • Excel Form Macro

    Hello Excel Gurus, I am in great need for an Excel Froms Macro that Switches a Spin Control (asignes integer value) to a cell and is mux'ed betwen different cell references that are activated by a radio button. I created a model code fragment well over a year ago and got the functionality to work...

    Dinosaur995 pointsBadges:
  • Copy and paste in Excel using Visual Basic scripting?

    First of all - Thank you.... I receive info in Excel worksheet "A" with columns of variable length which I want to cut and paste into Excel worksheet "B". Worksheet "A" info starts at B:13 and can range in length from 1 to 200 rows or more. I would like to copy this variable length information then...

    Bmac5 pointsBadges:
  • Can you help with the following DAO code explaining a step-by-step process?

    I’ve had some exposure to VBA and know the Access Interface very well (Microsoft Certified). I purchased MS Access 2007 Programming By Example by Julitta Korol a couple of months ago and all of the hands-on examples display the results in the Immediate window or a msgBox. Although I was able to...

    Doc3310 pointsBadges:
  • EXCEL find-copy-paste

    Hello! Using VBA for first time, so everything is toughed for me.. The problem is: we need to find on the first sheet named SD in second column all cells contianing word 'drilling', then for each cell copy row which contains that cell and paste it in other sheet or book (doesn't matter). Please...

    Snursmursik5 pointsBadges:
  • Add module to remote access database

    I have 100+ access 2000 .mdb's that I need to add a specific module to. What I want to do is loop through all mdb files in a specific directory and add a standard module to each one. Any ideas as to how to accomplish this from within access vba would be appreciated. I intend to do this from within...

    Ttstudio45 pointsBadges:
  • VBA-question

    How do I transfer 30 text files at a time into my access DB? I was able to get the files, but it did not transfer into the database. Thanks.

    Bonjour15 pointsBadges:
  • Error 2501

    While navigating my database I have a button that will take you to a different form using parameters. It works when you either simply click ok or type in a parameter, but when you click cancel it returns an error 2501. What code should i put in to VBA to make it simply close the parameter box and...

    Newguy20085 pointsBadges:
  • programming

    Tag# 301-22-AB02-103, I want this Tag format in this formate XXX-XX-NNXX-XXX, it means in place of Numbers i want 'X' and in Place of alphabet i want 'N', do you know how can you we do that in Excel? i wana to change numeric values in 'X' and alphabet in 'N' form, and my friend did already, through...

    0717855 pointsBadges:
  • Change Font Style of Menu Item Through VB6

    My program is in varnacular language, i. e. input and output are in Gujarati (Indian) language, by changing the font to "Gopika.ttf". So, during the execution of my program I want to show menus also in Gujarati. Normally, we change this from desktop --> properties --> appearnce -->...

    Mayuri155 pointsBadges:
  • Copy past in excel using VB

    i want to cut data in a colunm H and copy it in column B. i tried to record macro and run it. but i am not getting the values in column B. i am using excel macro and vb code to do this. i understand that the data in colum is cut and the data is not retrived while it paste in column B. Can Any one...

    Krishsrikanth5 pointsBadges:
  • Changing Color in a Cell

    I am updating a spreadsheet each month which is automated. I have written a macro to update this spread. Each month I append four columns to the end of the spread sheet and update the data in the spreadsheet. The problem that I am having is trying to figure out how to update the heading color for...

    Kioh4650 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