in
All Tags » VBA » select (RSS)

Browse by Tags

  • Using A Variable In VBA SELECT Statement

    I have a function that is called from my form. I am hard coding a variable into the function simply for testing will implement after the SELECT statement syntax is correct. I need help with the syntax. I use the following below and I receive error "Too few parameters. Expected 1" The important...
    Posted to Access (Forum) by microsoft on 02-10-2010

  • SELECT FROM SELECT in VBA?

    I'm writting a VBA code in Excel. This code connect to an Access DB, and everything is fine. I can make some SELECT query and i get all the informations that i need. But when i get to this specific Query, it doesn't work. And if i put this query inside an Access Query, everything is fine. So...
    Posted to Access (Forum) by microsoft on 11-26-2009

  • Excel VBA: select a column by its name.

    Not knowing much about VB or Excel, I can't do something that should be easy I want to select an entire column. I have Dim sourceWS As Worksheet Dim sourceSerialCol As Range Set sourceWS = ActiveWorkbook.Worksheets("report1251312094427 1 ") Set sourceSerialCol = sourceWS.Columns("Serial_Number"...
    Posted to Excel (Forum) by microsoft on 10-31-2009

  • VBA Selecting multiple cells

    This one should be easy. I need to select multiple cells in Excel. The macro recorder gives me: Range("D11,D13,D23,D27").Select However, I'm selecting in a loop and don't know the column letter. I there a way to select multiple cells using Activecell.offset or a R1C1 format?
    Posted to Excel (Forum) by microsoft on 08-20-2009

  • Access VBA - SELECT @@IDENTITY question

    I have the following code that is fired from an Access form's button's click event: --------------------------- strSQL = "INSERT INTO tblProductLineRules (ProductLineID, RuleSeq) VALUES (" & _ lngProductLineId & "," & _ lngRuleSeq & "); SELECT @@IDENTITY"...
    Posted to Access (Forum) by microsoft on 08-17-2009

  • Excel VBA Select Populated Cells

    I was trying to get code that would select all populated cells to the right the selected cell and all rows below it that are populated. Basically i have the uppermost cell selected how do I select the rest of the populated range. All of the cells in the range are populated. Thanks
    Posted to Excel (Forum) by microsoft on 08-15-2009

  • Select case VBA help

    Hi Experts....I have a combobox (Plan_ID) on my form that gets its data from a Table (Tbl_Affordent). The values in this fields are: Plan_ID (autonumber) Plan_Code: Plan_Description 1 A Item A 2 B Item B 3 C Item C The Combobox looks up the data and stores it on the form in a field (Plan_ID; Numeric...
    Posted to Access Coding/Macros (Forum) by microsoft on 07-14-2009

  • Select column A:A despite merged cells in a1:c1

    I find that I often use Selection.entirerow.select in various vba projects. But, as everybody knows, merged cells cause problems. For instance, the following code will select 3 columns even though I only want one column [a1:c1].mergecells=true [a:a].select Nonetheless, column A can be selected MANUALLY...
    Posted to Excel (Forum) by microsoft on 07-08-2009

  • AutoFilter VBA

    An Autofilter can select rows that are not in sequence, A1,A5,A7,A9, etc. I need a VBA function that will put the contents from an autofiltered column into a text string, each separated by a comma. So, if A1 contains 'a', A5 'b', A7 'c' and A9 'e', the text string returned...
    Posted to Microsoft Office (Forum) by microsoft on 06-30-2009

  • Excel VBA User Form - need to enter item number and return item description and other data

    I have a large Excel Workbook "M8 Working 20090224.6.xls". It has a Table of all possible inventory items in Sheets.("D"). I have a user form where users can add items to a bill of materials in Sheets.("SUMMARY")... Originally they were to add item number, description, etc...
    Posted to Excel (Forum) by microsoft on 06-30-2009
Page 1 of 2 (20 items) 1 2 Next >