Excel VBA Questions and Answers

Recent IT Questions

1 - 18 of 18
<<PREVIOUS 1 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.

Microsoft Excel VBA

'Please, Tell me this problems How to solve 'One cLick on cell at a time appeared date only Specific column and rows Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) ActiveCell.FormulaR1C1 = Now() ActiveCell.Offset().Range("A1").Select End Sub 'Thanx

Answer Question   |  Jun 16 2009  9:33 AM GMT
Excel VBA, Micosoft Excel
asked by 9833146658

  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.

Inventory work for storeroom using Excel VBA

Im supposed to do inventory for a store room at work using excel. Oraganizing and labeling all the items in there so that my boss can be able to find what he wants easily by simply for example if he wants a clock he looks for clock and he sees its at b1 and he looks for b1 and that specific item...

View Answer   |  Jun 2 2009  3:19 AM GMT
Excel VBA, Microsoft Excel
asked by Emozae

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

Is there any way to know on which date data was entered on a specific cell?

Is there any way to know which date data was entered or changed on a specific cell/

View Answer   |  May 19 2009  10:14 PM GMT
Excel VBA
asked by Dbrody

  5 pts.

Excel VBA - Cell value not being displayed

when i display all the values there is a cell that dosnt display it's result,but when u put the mouse on it in the comment box it appears

View Answer   |  May 19 2009  8:43 AM GMT
Excel VBA, Microsoft Excel 2007, Microsoft Excel
asked by Skh80

  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.

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.

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.

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

Answer Question   |  Apr 10 2009  11:28 PM GMT
VBA, Excel VBA, Excel 2007
asked by Lostinspace2000

  5 pts.

Looping to create new workbooks using a set "transaction" number

I'm playing around a bit and can't figure out why the following code does not save a total of 5 files in My Documents(default) The files should be named in a sequence of 1 - 5 (In my Excel spreadsheet (A1)=1 and (A4)=5) The code works once through, but when ".SaveAs Filename:=Start" comes back...

View Answer   |  Mar 6 2009  10:49 PM GMT
VBA, Excel VBA, LOOP statement
asked by McNitro

  155 pts.

Can any one correct this Microsoft Excel VBA code?

ANY ONE CORRECT THIS Sub fill_series() Dim myrange As Range Set myrange = ActiveCell.Offset(0, 5) Range("N9").FormulaR1C1 = "Apr-2008" Range("N9").Select Selection.AutoFill Destination:=myrange, Type:=xlFillDefault End Sub

Answer Question   |  Feb 24 2009  9:47 AM GMT
Excel VBA, VBA, Visual Basic for Applications
asked by Sa29153

  40 pts.

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

Answer Question   |  Feb 24 2009  9:46 AM GMT
Excel VBA, VBA, Visual Basic for Applications
asked by Sa29153

  40 pts.

1 - 18 of 18
<<PREVIOUS 1 NEXT>>