Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.04 seconds.

  1. Replies
    7
    Views
    134

    Jimmy, Yes, you can delete them once you are...

    Jimmy,

    Yes, you can delete them once you are sure that the code acts the way you expect it. However, if you ever need conversions in the future that do not involve hash tags and you want leading...
  2. Reitz, You did not specify the nature of you...

    Reitz,

    You did not specify the nature of you problem but here are several things we need to do:

    1. Make sure you are not placing a form control button instead of an active x control. With...
  3. Reitz, Borrowing from RG, I amended the code...

    Reitz,

    Borrowing from RG, I amended the code to add in the user's name to the transfer in column 8. As before, the code will transfer as many lines that are present but I added in the code to...
  4. Replies
    4
    Views
    66

    RG, Nice! Your concept makes much more sense...

    RG,
    Nice! Your concept makes much more sense than my approach when used in the Workbook_BeforeClose



    ' Create a global variable to store the default save file format.
    Dim MyCurrentSaveFormat...
  5. This will use your naned ranges that already have...

    This will use your naned ranges that already have your formulas applied:



    Sub ChangeAxisScales()
    Worksheets("Dash2").ChartObjects("Chart 8").Activate
    With ActiveChart.Axes(xlValue)...
  6. Replies
    4
    Views
    66

    How about a backdoor approach? If you enter a...

    How about a backdoor approach? If you enter a "password" on the first input box, the workbook will just close by bypassing the validation of the inputs. (Note: Not tested)




    ' Create a...
  7. Reitz, Once transferred, if you want the...

    Reitz,

    Once transferred, if you want the source data to clear and then close the source workbook, you will need to add the following lines (in blue) as the 3rd and 4th lines to the end in the...
  8. Replies
    5
    Views
    97

    [SOLVED] If you do not want the zeros to show, Place in...

    If you do not want the zeros to show, Place in C56 then copy down:


    =if(INDEX(C$30:D$54,MATCH(D56,D$30:D$54,0),1)=0,"",INDEX(C$30:D$54,MATCH(D56,D$30:D$54,0),1))
  9. Reitz, The following code will run when the...

    Reitz,

    The following code will run when the user clicks a Transfer Data Button. The code first checks to see if Global Journal workbook is already opened.

    If it is not, the workbook will...
  10. Idarley, Try this: Sub...

    Idarley,

    Try this:



    Sub ChangeAxisScales()
    Worksheets("Dash2").ChartObjects("Chart 8").Activate
    With ActiveChart.Axes(xlValue)
    .MaximumScale =...
  11. Replies
    5
    Views
    97

    [SOLVED] XP, in cell C56, try this formula and copy...

    XP,

    in cell C56, try this formula and copy down:

    =INDEX(C$30:D$54,MATCH(D56,D$30:D$54,0),1)
    It will return the matching 0/4 from the Source Scoring section

    You can wrap it in your IFERROR()...
  12. Replies
    7
    Views
    134

    Thanks Jimmy, You are absolutely correct. You...

    Thanks Jimmy,

    You are absolutely correct. You will have to comment out the following lines

    If Len(Base2) > 4 And Left(Base2, 4) = "0000" Then
    Base2 = Mid(Base2, 5)
    End If
  13. Replies
    7
    Views
    134

    Jimmy, Excel is not removing the leading zero;...

    Jimmy,

    Excel is not removing the leading zero; your code is. The following lines are your culprit:

    If Len(Base2) > 5 And Left(Base2, 5) = "00000" Then
    Base2 = Mid(Base2, 6)
    End If
    ...
  14. fwasmann, Here is the amended code that will...

    fwasmann,

    Here is the amended code that will copy the last sheet in the destination workbook if needed, append it to the end, then paste the values as before. Your formulas and formatting will be...
  15. fwasmann, The following code will open your...

    fwasmann,

    The following code will open your destination workbook and copy successive columns from you source workbook to successive sheets using the ranges you specify. If there are more columns...
  16. Replies
    5
    Views
    98

    You could copy it, keep it current on the clip...

    You could copy it, keep it current on the clip board, and the repeatedly paste. Another alternative would be to select a cell then Ctrl-V to paste instead of pasting via the context menu. Use your...
  17. Replies
    9
    Views
    897

    RG, Kudos on your intuitive insight that...

    RG,

    Kudos on your intuitive insight that anyone would want to use a drawing tool Textbox as an input mechanism on a sheet. Never would have guessed that especially since the OP's macro is exactly...
  18. Replies
    5
    Views
    98

    Can you draw a rectangle shape over the desired...

    Can you draw a rectangle shape over the desired text with the default set as: fill color set to yellow, transparency 70%, and no line?
  19. Replies
    9
    Views
    897

    JeanM, Insert Tab that RG speaks of is not to...

    JeanM,

    Insert Tab that RG speaks of is not to be confused with the Insert button on the Developer tab which does allow the adding of active X controls which contain event subroutines.

    39430
  20. Replies
    9
    Views
    897

    There is only a Textbox_Exit if a textbox is...

    There is only a Textbox_Exit if a textbox is placed on a form

    HTH,
    Maud
  21. Replies
    9
    Views
    897

    There is no event Textbox_Exit. Try ...

    There is no event Textbox_Exit. Try




    Private Sub TextBox1_LostFocus()
    If TextBox1.Value = "" Then
    MsgBox "You must enter data"
    End If
    End Sub
  22. Correction on the AT&T phonenumber@txt.att.net

    Correction on the AT&T
    phonenumber@txt.att.net
  23. Red Coon, Did some research. Apparently,...

    Red Coon,

    Did some research. Apparently, sending an SMS is like sending an email. Phone carriers provide an address to convert emails to text messages:

    T-Mobile: phonenumber@tmomail.net ...
  24. Replies
    4
    Views
    111

    To round to other intervals, here is the complete...

    To round to other intervals, here is the complete formula:

    =ROUND(A1*24/x,0)*x/24

    where X is:
    X=1  round to nearest hour
    X=0.5  Round to nearest hour
    X=0.25  Round to nearest hour
  25. Replies
    8
    Views
    111

    Skipro, Although I can't duplicate it now, I...

    Skipro,

    Although I can't duplicate it now, I have seen this happen that after performing some function, the gridlines disappear leaving you with a block of white area. It has nothing to do with...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4