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...
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...
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...
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...
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
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
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...
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...
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....
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....
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
'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
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...
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...
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...
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...
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?
Do you know how to copy from excel and paste to a text file using VBA?
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/
Is there any way to know which date data was entered or changed on a specific cell/
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
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
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 ...
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 ...
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...
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...
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...
Answer Question
| Apr 21 2009 9:49 AM GMT
Microsoft Excel macros, Visual Basic for Applications, Microsoft Excel formulas
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...
Answer Question
| Apr 21 2009 9:49 AM GMTMicrosoft Excel macros, Visual Basic for Applications, Microsoft Excel formulas
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...
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...
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...
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...
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
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
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 ...
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 ...
1 - 18 of 18
PREVIOUS 1 NEXT
