Search:

Type: Posts; User: Maudibe; Keyword(s):

Page 1 of 20 1 2 3 4

Search: Search took 0.07 seconds.

  1. Replies
    5
    Views
    185

    Like Zeddy stated, you will have to make the...

    Like Zeddy stated, you will have to make the above changes to work outside of Excel 2013
  2. PStephens, The following User Defined Function...

    PStephens,

    The following User Defined Function will return the address of the validation list of a cell.

    If Cell A2 has a validation list of L4 to L8, in cell C2 for example, enter the formula:...
  3. Satnair, This code will cycle through the all...

    Satnair,

    This code will cycle through the all the sheets in the workbook and will print all but those listed in the specified line of code.

    HTH,
    Maud

    Place in a standard module:
  4. Replies
    5
    Views
    185

    Pako, This code will build your columns in the...

    Pako,

    This code will build your columns in the "Intervention Rate" sheet based on the data in the "Raw Data" sheet and the exceptions in your exceptions list. I assumed that the exceptions in the...
  5. gade.vano, This amended code will place the...

    gade.vano,

    This amended code will place the values from multiple Excel rows from the range C4 to C21 into the bookmark "ID" within the Word document.

    HTH,
    Maud



    Sub...
  6. Replies
    19
    Views
    351

    Howard, Do you may want the formulas in column...

    Howard,

    Do you may want the formulas in column A rather than column B as your formulas suggest? Aside from Zeddy's code, this will also work.



    Private Sub ComboBox1_Change()
    For I = 4...
  7. Replies
    19
    Views
    351

    Howard, The months are on a hidden spreadsheet...

    Howard,

    The months are on a hidden spreadsheet (xlSheetVeryHidden) called "settings" in the range A2:A12. Note the list range in the properties window for the combobox

    42900
  8. Replies
    19
    Views
    351

    Howard, The following code will take the...

    Howard,

    The following code will take the selected value of a combobox and place it in the formula as you described. The formula is in cell A5.

    HTH,
    Maud



    Private Sub ComboBox1_Change()
  9. Replies
    23
    Views
    639

    I am Blind-sided by some of these PUNs from some...

    I am Blind-sided by some of these PUNs from some of my contacts on this web sight.
  10. Caeser, Attached is the revised workbook. ...

    Caeser,

    Attached is the revised workbook. Added features are:

    1. Form Creation: You can control the number of forms to be created by selecting a number of records (<=16) by highlighting the...
  11. Unclehewie, You make a good point of selecting...

    Unclehewie,

    You make a good point of selecting which forms to print. I was looking at it from the point of view by selecting which records to send to the forms. I will incorporate your thoughts...
  12. Ceasar, Good question about column H. If you...

    Ceasar,

    Good question about column H. If you look at the form, starting at first name and counting down, you will notice that the line with "Order information" is the 8th line. On the Order...
  13. Replies
    23
    Views
    639

    20 lashes for that joke!

    20 lashes for that joke!
  14. Replies
    2
    Views
    80

    Thanks Zeddy, What is the true extension?

    Thanks Zeddy,

    What is the true extension?
  15. Replies
    23
    Views
    639

    Zeddy, OUTSTANDING!!!!!

    Zeddy,

    OUTSTANDING!!!!!
  16. Zeddy, Pop your ear out the window. It's only...

    Zeddy,

    Pop your ear out the window. It's only 8,000 miles+ between us and unfortunately, recent events show that I have a big mouth!
  17. Replies
    23
    Views
    639

    RG, Thanks for the follow-up. I too have a...

    RG,

    Thanks for the follow-up. I too have a core I7 but first generation oc to 4.2GHz. Maybe not as fast as yours. Using your "beast rig", could you try doubling the x-y-pixels in the line Do...
  18. danny, Several ways to do this. Here is a...

    danny,

    Several ways to do this. Here is a quick way (note the changes in blue):



    Sub doIt()

    Dim data As Variant
    Dim i As Long
  19. Replies
    11
    Views
    275

    Glad we watch each others backs!

    Glad we watch each others backs!
  20. Replies
    1
    Views
    107

    testing video upload

    http://youtu.be/DQMVhpwKk2U

    http://youtu.be/DQMVhpwKk2U
  21. Replies
    23
    Views
    639

    RG, There is a loop in the code. Strange that...

    RG,

    There is a loop in the code. Strange that I can go up and down the entire range and the highlighting of the rows will follow for about 5 seconds. Are you keeping your cursor with in the data...
  22. Replies
    11
    Views
    275

    RG, Nice job on your UDF. A tweak to prevent...

    RG,

    Nice job on your UDF. A tweak to prevent a blank space in the row from stopping the code short. You can enter the entire range into the formula:

    in cell L2 =iIncDivCnt(D2:J2)

    42856
    ...
  23. Replies
    23
    Views
    639

    As RG pointed out, a mouseover for a textbox has...

    As RG pointed out, a mouseover for a textbox has no practical application in Calvin's needs. I initially was working with a hyperlink formula to point to the macro but that would mean that every...
  24. Replies
    23
    Views
    639

    RG, I am sure you can do something with the...

    RG,

    I am sure you can do something with the code here to make it work

    http://windowssecrets.com/forums/showthread.php/165438-Instructions-for-textboxes

    Maud
  25. Sounds like a pretty big project. Can you go...

    Sounds like a pretty big project. Can you go into more detail?
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4