Showing progress bar form during QueryTables
Hi, I’d like to add a form on my VBA Excel showing a progress bar during data downloading or during other DB process. I’m using VBA QueryTables to download from an Oracle db, PivotTableWizard to download it on a pivot table and ADODB Execute to execute stored procedures. Thanks for your help.
Answer Question
| October 1, 2012 10:14 AM
Excel VBA, VBA functions
Hi, I’d like to add a form on my VBA Excel showing a progress bar during data downloading or during other DB process. I’m using VBA QueryTables to download from an Oracle db, PivotTableWizard to download it on a pivot table and ADODB Execute to execute stored procedures. Thanks for your help.
VBA Copy and Paste using dates
I have a spreadsheet that I am compiling for completed work orders. The sheet I want to copy the information from is called “Completed”. In column H, I have the date each work order was completed and the dates are formated mm/dd/yyyy. I would like to have a code that will copy the work orders [...]
Answer Question
| March 7, 2012 6:23 PM
Excel VBA, Microsoft Excel 2003, Microsoft Office VBA
I have a spreadsheet that I am compiling for completed work orders. The sheet I want to copy the information from is called “Completed”. In column H, I have the date each work order was completed and the dates are formated mm/dd/yyyy. I would like to have a code that will copy the work orders [...]
Unlocking VBA project using VBA code
Can i use vba code to unlock my x-cel vba project protected by password? I need to unprotect my project to add some code and then reprotect it.
Answer Question
| December 25, 2010 3:29 PM
Excel 2003, Excel 2003 functions, Excel VBA, VBA, Visual Basic
Can i use vba code to unlock my x-cel vba project protected by password? I need to unprotect my project to add some code and then reprotect it.
Excel 2003 Macros with Org Chart Parent
Hello, I have a corporate org chart for which I am trying to write a macro. The Excel workbook is set up so that each company is in a unique cell. The subsidiary is one column to the right. For instance, I would like to return the values in the far right column for the [...]
Answer Question
| March 11, 2011 3:53 PM
Excel 2003, Excel 2003 macros, Excel macros, Excel Tables, Excel VBA, Macros
Hello, I have a corporate org chart for which I am trying to write a macro. The Excel workbook is set up so that each company is in a unique cell. The subsidiary is one column to the right. For instance, I would like to return the values in the far right column for the [...]
Cell Automated Population using Excel macro
Hi, is there a way in macro wherein if a certain cell has value, the other cells will be automatically populated? Example: In cell E6 I put the date, cell A6, B6,C6 and D6 will automatically copy the values in A4, B4, C4 and D4. Same goes when I enter the date on cell E7. Thank you [...]
Answer Question
| December 8, 2010 8:33 AM
Excel 2003, Excel macros, Excel VBA, Visual Basic
Hi, is there a way in macro wherein if a certain cell has value, the other cells will be automatically populated? Example: In cell E6 I put the date, cell A6, B6,C6 and D6 will automatically copy the values in A4, B4, C4 and D4. Same goes when I enter the date on cell E7. Thank you [...]
VBA Excel 2003 Copy and Paste
I would like to know how am i going to copy a certain range (A1:E500) in File A and paste it in a different file (File B). Then copy a new range in other sheet of File A then paste it in File B without overlapping the data I copied from the first range. Thank you [...]
Answer Question
| November 16, 2010 4:08 PM
Excel 2003, Excel VBA, VBA, VBA EXCEL 2003
I would like to know how am i going to copy a certain range (A1:E500) in File A and paste it in a different file (File B). Then copy a new range in other sheet of File A then paste it in File B without overlapping the data I copied from the first range. Thank you [...]
Excel VBA Count # of Cells within Max and Min in a Table
How do you write a VBA macro that count the numbers cell within a selected table that falls between a maximum and minimum number?
Answer Question
| November 25, 2010 3:24 AM
COUNTIF statement, Excel VB code, Excel VBA, Visual Basic
How do you write a VBA macro that count the numbers cell within a selected table that falls between a maximum and minimum number?
I need vba code to update item cost from a word document w/o changing the previous wks item cost in Excel 2004
I have a work book with week 1 – 5 ending inventory worksheets. I need vba code to update item cost from a word document w/o changing the previous wks item cost.
Answer Question
| July 15, 2010 1:52 AM
Excel 2004 Workbooks, Excel VBA, Excel worksheets, Visual Basic
I have a work book with week 1 – 5 ending inventory worksheets. I need vba code to update item cost from a word document w/o changing the previous wks item cost.
VBA Excel – paste not working
I have the following piece of code attached to my Excel worksheet: ActiveSheet.Shapes(“Object 407″).Select Selection.Copy Range(“BP106″).Select ActiveSheet.Paste The code is activated by making a choice in a drop down in the worksheet. The worksheet is password protected but the cell BP106 is not locked. When I make a selection from the [...]
Answer Question
| June 28, 2010 3:18 PM
Excel 2007, Excel VBA, VBA, Visual Basic for Applications
I have the following piece of code attached to my Excel worksheet: ActiveSheet.Shapes(“Object 407″).Select Selection.Copy Range(“BP106″).Select ActiveSheet.Paste The code is activated by making a choice in a drop down in the worksheet. The worksheet is password protected but the cell BP106 is not locked. When I make a selection from the [...]
Conditional Hiding of Rows in Excel
Hi, I work on some projects and I maintain status of those in an excel file in column L. The status of the projects varies as I wrok (Stages). The final status of the project is named as “Completed”. Now I want the whole row to get hide when I select the status “Completed” from the list. [...]
Answer Question
| April 8, 2010 6:45 AM
conditional hiding rows, Excel VBA, Hiding rows
Hi, I work on some projects and I maintain status of those in an excel file in column L. The status of the projects varies as I wrok (Stages). The final status of the project is named as “Completed”. Now I want the whole row to get hide when I select the status “Completed” from the list. [...]
vba loop help
i am trying to run a simple loop, paste code. i am new to excel vba and am trying to teach myself. here is what i want to do, take the numbers one through ten and paste them one at a time into x. it looks like this. 1 x 2 3 4 5 6 [...]
Answer Question
| February 19, 2010 4:14 PM
Excel 2003, Excel VBA, Microsoft Excel, VBA
i am trying to run a simple loop, paste code. i am new to excel vba and am trying to teach myself. here is what i want to do, take the numbers one through ten and paste them one at a time into x. it looks like this. 1 x 2 3 4 5 6 [...]
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 [...]
Answer Question
| March 29, 2010 10:45 AM
Conditional statements, Excel VBA, VBA, Visual Basic for Applications
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 [...]
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 frequently I get something along the lines of [...]
Answer Question
| August 12, 2009 12:21 AM
Excel VBA, Microsoft Excel, VBA, Visual Basic for Applications, VLOOKUP 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 frequently I get something along the lines of [...]
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
| January 23, 2012 6:46 AM
AutoNumber, Excel 2007, Excel VBA, VBA, Visual Basic for Applications
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 [...]
Answer Question
| July 8, 2009 4:38 AM
ComboBox, Excel VBA, Microsoft Excel, VBA, Visual Basic for Applications
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 [...]
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. <pernr> Verify: 1. [...]
Answer Question
| June 23, 2009 11:33 PM
Excel VBA, Microsoft Excel, VBA, Visual Basic for Applications
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. <pernr> Verify: 1. [...]
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
| June 16, 2009 9:33 AM
Excel VBA, Micosoft Excel
‘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 G1 and looks for text that is in that cell.. G1 changes often. Thanks Charlie
Answer Question
| June 12, 2009 6:18 AM
Excel VBA, Microsoft Excel, VBA, Visual Basic for Applications
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 G1 and looks for text that is in that cell.. G1 changes often. Thanks Charlie
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 [...]
Answer Question
| June 5, 2009 3:19 AM
Excel VBA, Microsoft Excel
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 [...]
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?
Answer Question
| February 2, 2012 9:38 PM
Excel VBA, Microsoft Excel, VBA, Visual Basic for Applications
Do you know how to copy from excel and paste to a text file using VBA?





