Visual Basic For Applications Questions and Answers

Recent IT Questions

1 - 20 of 75
<<PREVIOUS 1|2|3|4 NEXT>>

format cell based on contents using VB

i need to change the color of a cell in a specified column based on the value e,g if A1 value is between 1 and 10 then the colo will be red, if the value is between 11-20 then the color will be green etc. i used conditional formats but they only allow for 3 variables i need a script or other that...

View Answer   |  Jul 14 2009  10:45 AM GMT
VBA, Excel VBA, Conditional statements
asked by Voicetec

  15 pts.

Vlookup Worksheet Function

I develop and maintain pricing models that involve a lot of looping through cells and applying assumptions. For some reason I never seem to be able to get the vlookup worksheet function to work when looping through cells. It either says 'application-defined or object-defined error' or more...

asked by Hunter11

  5 pts.

how to create autonumber

while press enter on cell (b1) the cell (a1)= 1 while press enter on cell (b2) the cell (a2)= 2 and so on i tried functions : =row() and =OFFSET(A2,-1,0)+1 i don't think its an autonumber because i used manualy so, hlp pls

Answer Question   |  Jul 10 2009  6:46 AM GMT
Excel VBA, VBA, Visual Basic for Applications
asked by Army

  100 pts.

Combobox Intro. Question

Hi! I'm extremely new at using combobox in Excel and I have 2 questions about how to incorporate them into my files. 1.) Is there software that I can use to "produce" the VB code I need to set my comboboxes over my Data Validation cells? Not used to actual programing. 2.) I wanted to know if...

Answer Question   |  Jul 8 2009  4:38 AM GMT
Excel VBA, ComboBox, VBA
asked by Kiki8302

  5 pts.

Extract all instances of a search between two symbols

Dear Friends, I have created the following code to search entire C Column from WrkBk1 with "<*>" string so as to extract all the matched words into Wrkbk2. for eg a single cell data in Col-C is given below maintaining similar pattern in other cells too. [Cell C1 Data] Enter Pers No....

Answer Question   |  Jun 22 2009  11:33 PM GMT
Excel VBA, Visual Basic for Applications, VBA
asked by Gotovamsee

  5 pts.

Excel VBA cell.find

I have this code recorded by XL. Works ok. ** Cells.Find(What:="dd", After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _ xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False) _ .Activate End Sub ** In the first part - (What="dd", I want the macro to read Cell...

Answer Question   |  Jun 12 2009  6:18 AM GMT
VBA, Excel VBA, Visual Basic for Applications
asked by Sswcharlie

  5 pts.

VBA copying a range from Excel and pasting to a text file

Do you know how to copy from excel and paste to a text file using VBA?

View Answer   |  May 27 2009  9:38 PM GMT
VBA, Excel VBA, Microsoft Excel
asked by TBone55

  5 pts.

VBA format a cell based on range contents

I need to create a macro that goes in to a worksheet and looks at the contents of a range to see if it contains any number other than zero. If it does, I need it to turn a separate cell yellow. 'assign variables Dim rngSat As Range Dim rngSun As Range Dim wsOT As Worksheet ...

View Answer   |  May 14 2009  5:11 AM GMT
VBA, *RANGE, Conditional formatting
asked by VbaNewb13

  15 pts.

Access 2007: VB code to make a button press link to a specific record in another form

The database is for a set of components. One of my forms shows details about each component on a separate record (the property "Default View" is Single Form). The other form is a list of all components by component number displayed all together (the property "Default View" is Continuous Forms)....

View Answer   |  May 11 2009  9:59 PM GMT
Access VBA, Microsoft Access 2007, VBA
asked by VinDibo

  5 pts.

Copy/paste a record with VBA in Microsoft Access

how can I copy number of records from a form and paste them in another form with VBA, not with the right click, in msaccess? Thanks

View Answer   |  May 9 2009  3:37 PM GMT
VBA, Microsoft Access, Visual Basic for Applications
asked by Toli

  70 pts.

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...

Answer Question   |  May 4 2009  5:41 AM GMT
VBA, Microsoft Excel 2003, TreeView
asked by Maheshvba

  5 pts.

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...

View Answer   |  Apr 28 2009  11:22 PM GMT
Microsoft Access, NULL values, Microsoft Access forms
asked by Wesleycrozier

  30 pts.

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...

View Answer   |  Apr 28 2009  11:04 AM GMT
Outlook 2003 calendar, Excel 2003, Exchange 2003
asked by Yosiniro

  5 pts.

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?

asked by Flyght

  55 pts.

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...

Answer Question   |  Apr 23 2009  4:40 AM GMT
Microsoft Excel, VBA, Microsoft Excel macros
asked by Gahlan

  5 pts.

ComboBox in Microsoft Excel VBA

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

View Answer   |  Apr 22 2009  8:16 AM GMT
Microsoft Excel, VBA, Microsoft Excel macros
asked by Narmadha

  5 pts.

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...

asked by Cmb80

  10 pts.

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 ""?

View Answer   |  Apr 14 2009  3:16 AM GMT
Visual Basic for Applications, Microsoft Excel, VBA
asked by Chilipepperz3

  5 pts.

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...

View Answer   |  Apr 8 2009  11:26 AM GMT
VBA, Microsoft Excel, Visual Basic for Applications
asked by Devisri

  20 pts.

DoCmd.OpenReport not working right with WHERE clause

I have looked all over and seen hundreds of questions about this command, but no answers. It seems like the most basic thing you can do with combo boxes, so I'm baffled that it doesn't work. Here is my VBA Code: Option Compare Database Private Sub cboFundNumbers_AfterUpdate() Const...

View Answer   |  Apr 1 2009  10:20 PM GMT
Access 2003, VBA, DoCmd.OpenReport
asked by Pubfin

  15 pts.

1 - 20 of 75
<<PREVIOUS 1|2|3|4 NEXT>>