vba programming

  1. D

    Vba Programming

    in my combo box i have selected a range as a drop down to show but the range has multiple duplicate entries how to combine the same values to show as one in the combobox right now range is like this indirect costs indirect costs indirect costs sitework sitework sitework concrete...
  2. M

    workbook require (trendline coefficient)

    Hello everyone, please, if somebody has the workbook corresponding to the trendline coefficients written by Tushar in his site ("http://www.tushar-mehta.com/publish_train/data_analysis/16.htm), at the end he has the code, but I need to see the spreadsheet, where is the inputs and outputs...
  3. A

    Import the data from EXcel

    Hi Guys, I have a button in Access Database, but i don`t have a functionality. I need whenever i press "Import Button" it will automatically open the filer and i will navigate to select multiple files of excel anywhere in my hard drive. when i import the data it will automatically import all...
  4. A

    Excel VBA Code Problem

    Hello...... Can you all tell me please how do i select one sheet from 2 sheets in excel. For example: I need to select to search for a name of sheets from 3 sheets. Worksheets("Seet2" or "Seet4") Can i do like that?
  5. M

    (vba) adding an input

    Hello, I am uploading a code, but I would like to be able to enter the range I want every time. the code loop the frequency function all the way down an array at B2:G2066. work good but I need to explore different ranges, the range the code has is 18 row every time it run, so would be good at A1...
  6. M

    (vba) looping frequency function

    http://s1358.photobucket.com/user/murcielago27/media/LOOPINGTHEFREQUENCY_zps9214b6e7.jpg.html Hi every one<o:p></o:p> A picture isworth a thousand words, agree, I upload a picture . I am in the chapter of LOOPS, but I don’t see what I really need.<o:p></o:p> How to loop the “frequency...
  7. M

    (vba) loop concepts

    Hello. what kind of reasoning I have to apply, to understand how from the simple loop code here: Sub looptest()<o:p></o:p> Dim i As Integer, j As Integer<o:p></o:p> For i = 1 To 6<o:p></o:p> For j = 1 To 6<o:p></o:p> Cells(i, j).Value = i * j<o:p></o:p> Next j<o:p></o:p> Next...
  8. M

    (vba) SWAPING THE VALUES FROM THE FREQUENCY REPORT

    SWAPING THE VALUESFROM THE FREQUENCY REPORT.<o:p></o:p> Manually I used the frequency function to know whatfrequency every number in every row has.But NOT including the row right above. I mean, the first frequency is B3:G21and the row to be swap is B2:G2.<o:p></o:p> The row B2:G2 is...
  9. M

    adding array

    hello everyone. I am trying to understand about loops, so I want to see, what loop to use if I need to sum an array row by row, I am learning by myself. I want to see if you use, for...next or do while or ???. . <colgroup><col width="64" style="width: 48pt;" span="8"> <tbody> 1 2 3...
  10. P

    Merging Columns based on two criteria

    Dear all,. I'm fairly new to VBA programming. I would like to merge 7 columns if two conditions are meet. Start Week Ending week Jan Feb Mar Apr May Jun July Aug Sept Oct Nov Dec 7 11 7 11 12 1 53 1 1...
  11. M

    trunc function

    Hello, I know if I use trunc function is to avoid decimals, so I am trying to write a code, and I have this line Range("J" & lRow) = Cells(lRow, "I")/ 6 HOW TO AVOID THE DECIMALS in this case. thanks for any help. <o:p></o:p>
  12. S

    Counting highlight values

    HELLO, PLEASE, I NEED TO COUNT HIGHLIGHT VALUES, VERTICALLY AND HORIZONTALLY, IS AN ARRAY. THE EXAMPLE HERE IS REALLY SMALL BUT MY DATA IS H1:M36 HERE IT IS MY EXAMPLE. <colgroup><col width="64" style="width: 48pt;" span="9"> <tbody> H I J K L M N O 1 1 2 3...
  13. C

    Highlight duplicates row by row (not columns)

    Hello, I need to highlight duplicates row by row (NOT BY COLUMNS), to compare two arrays. I trying countif and conditional formatting and avoid the absolute value, but, I have to go row by row, So, there are another function or maybe a vba code for it. here it is my tow arrays...
  14. M

    Looping through a multi dimensional array

    Hello everyone<o:p></o:p> Step 1- I used trunc(average(A2:A5))<o:p></o:p> Step 2- I compare the results against A1:G1<o:p></o:p> Step 3- I count how many duplicates I found in this way<o:p></o:p> And again start steps 1 trough 3, with the next line I meancompare the average of the A3:A6 against...
  15. M

    time card problem

    Hello, I would like to see how to make my time card on vba, example: <colgroup><col width="80" style="width: 60pt; mso-width-source: userset; mso-width-alt: 2925;"> <col width="64" style="width: 48pt;" span="3"> <col width="70" style="width: 53pt; mso-width-source: userset; mso-width-alt...
  16. M

    (vba) Sub headingsInsert() how work

    Hello everyone. I am trying to make a little changes in a code but here in the headingInsert when I try to change the cell D1:Q1 and the cell I:I for another position then desapear. for me looks like seal unit, I can change nothing. please somebody can explain me how can I make any change I want...
  17. M

    snippet code for sum two values

    happy new year all. I would like to see a snippet code for adding two simple cells, I would like to write a number in A1 and another in A2 and get the result in A3
  18. M

    From macros to vba (substractions)

    Hi, everybody Happy new year to all. I would like some code for some substraction that I need. <colgroup><col style="width: 24pt; mso-width-source: userset; mso-width-alt: 1170;" width="32"> <col style="width: 16pt; mso-width-source: userset; mso-width-alt: 768;" span="6" width="21"> <col...
  19. M

    (vba)conditional formatting

    Happy holiday and Happy new year for all. I am trying to use conditional formatting without use F4 so I can scroll down, but, do not work, why? I don't know. I am looking for a VBA code (not formulas). my situation is: data : B3:G64 results start in: M2 what I am trying to do? I want to...
  20. M

    unique list by rank

    I need to got the list according to the rank. <colgroup><col style="width: 48pt;" span="5" width="64"> <tbody> A B C D 1 bin score rank 2 1 37 3 2 48 4 3 31 5 4 18 6 5 31...

Some videos you may like

This Week's Hot Topics

Top