Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.04 seconds.

  1. Replies
    5
    Views
    105

    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
  2. Replies
    5
    Views
    105

    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
    ...
  3. 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...
  4. 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...
  5. Replies
    5
    Views
    89

    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...
  6. Replies
    9
    Views
    791

    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...
  7. Replies
    5
    Views
    89

    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?
  8. Replies
    9
    Views
    791

    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
  9. Replies
    9
    Views
    791

    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
  10. Replies
    9
    Views
    791

    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
  11. Correction on the AT&T phonenumber@txt.att.net

    Correction on the AT&T
    phonenumber@txt.att.net
  12. 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 ...
  13. Replies
    4
    Views
    98

    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
  14. Replies
    8
    Views
    106

    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...
  15. Replies
    5
    Views
    95

    Alan, I agree, all the members in this forum...

    Alan,

    I agree, all the members in this forum are great; those who present the challenge and those who help resolve them. But in all fairness to Eileen's lounge, Tech Teacher asked for a formula...
  16. RG, For a 10 loop procedure, yes you would...

    RG,

    For a 10 loop procedure, yes you would need really fast fingers. But is it really clear that the working copy may not be 1000 cells in the range? And who is to say that additional code may...
  17. It could easily send an email instead to her...

    It could easily send an email instead to her and/or anyone else involved. Not sure about a SMS though.
  18. Capn-ken, If you have anything running...

    Capn-ken,

    If you have anything running unnecessarily in the back ground, try disabling it to conserve resources. Have you added any code recently that might be doing some intensive looping,...
  19. ...because if placed at the end and the code is...

    ...because if placed at the end and the code is interrupted mid loop, the likelihood of disabling the events becomes probable and the astute point you initially made become moot. Since interrupts...
  20. Focus, 1. The first thing that I would...

    Focus,

    1. The first thing that I would consider is converting the files to .xlsb format to reduce the size and memory consumption while speeding up the performance a bit.

    2. To make sure...
  21. Replies
    8
    Views
    106

    Sorry, following RG's lead. to put the borders...

    Sorry, following RG's lead.

    to put the borders back in place you can use the following combination sequences:

    Ctrl-Shift-7
    Ctrl-Shift->
    Ctrl-Shift-<
    Ctrl-Shift-7

    or same thing as hold the...
  22. oversight...good pickup but I would rather put it...

    oversight...good pickup but I would rather put it here.




    Private Sub Worksheet_Change(ByVal Target As Range)
    '---------------------------------
    'DECLARE AND SET VARIABLES
    Dim rng As...
  23. Red Coon, Although this is very doable, seems...

    Red Coon,

    Although this is very doable, seems like you are complicating things by throwing Outlook into the mix. Excel can monitor the dates, calculate date differences, and toss out a message...
  24. Replies
    4
    Views
    98

    If you wish to convert to the nearest hour (time)...

    If you wish to convert to the nearest hour (time) instead of an integer, use the formula:

    =ROUND(A1*24,0)/24

    Maud
  25. Bobby, Place the following code the worksheet...

    Bobby,

    Place the following code the worksheet module. This example is set up for a range of cells A1 through A10. If a 1 is entered in that range, it checks for the presence of another 1 and...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4