Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.06 seconds.

  1. Re: how can I get rid of white space before text in range

    This looks promising...

    https://smallbusiness.chron.com/remove-whitespace-string-excel-40333.html
  2. Re: Macro running on Shared workbook (Sharepoint)

    Jolly good.
    Can't provide any more info on sharing issues with array formulae & code, I'm afraid. Hopefully, some other Folk will chip-in...
  3. Re: Macro running on Shared workbook (Sharepoint)

    One thing to bear in mind - presumably you've had to hard-code the other workbooks' passwords, into your code; have you protected your actual VBA project - with a password? If not, users will be able...
  4. Re: Single or Multiple Variables to Populate Message Boxes in Different Subs

    I'm not an expert, by any means - and stand to be corrected (or shot down in flames) by some very clever Folk who help on this great site.
    That having been said, for my two pennies worth:

    1....
  5. Replies
    10
    Views
    102

    Re: Workbook should not open - code require

    ALWAYS test on a copy of your treasured work, FIRST!

    In case Steve's off line for a while.....
    Can you open your Excel application, go into macro security, and set it to disable all macros, or...
  6. Re: Using this barcode to split data into columns (pharmacy related)

    If the GTIN's always first, then that one's easy: =MID(A1,3,14)
    If the Exp date's always second, then that one's easy: =MID(A1,19,6)

    Not at all sure about retrieving the Lot# - bearing in mind...
  7. Re: Using this barcode to split data into columns (pharmacy related)

    Is the GTIN always first, and the Exp date always second?
  8. Replies
    7
    Views
    123

    Re: Warning Message for non-zero check figures

    Thanks for the feedback.
    You can always give the VBA a go, if you fancy it, or if John's solution doesn't work out for you. Happy to talk you through it, if necessary.
  9. Replies
    10
    Views
    102

    Re: Workbook should not open - code require

    Private Sub Workbook_Open()
    If Sheets("Sheet1").Range("A1").Value = Date Then Exit Sub
    If InputBox("Password please", "Password check") <> "Password" Then Me.Close (False)

    End Sub
    You'll need...
  10. Replies
    10
    Views
    102

    Re: Workbook should not open - code require

    Use the search facility - there shouldn't be any need to post for this.
    There are hundreds of similar posts here, about this subject - just do a search for "Password protect workbook" or similar.
  11. Replies
    7
    Views
    123

    Re: Warning Message for non-zero check figures

    DerpDerp24 Did this work for you?
  12. Replies
    4
    Views
    91

    Re: VBA code to clear range and text box

    kroters Did this do the trick?
  13. Re: Wondering whether a formula could assist or is even possible ...

    I could easily manage 3.5, but 35's getting silly! Spent quite a bit of time in the Middle East, when I was flying, and endured 50 C a few times. That wasn't funny! Not even a titter...

    Glad...
  14. Replies
    5
    Views
    149

    Re: Alert - First Monday of the Month

    I went for this...
    =IF(AND(DAY(TODAY())<8,TEXT(TODAY(),"DDD")="Mon"),"Project","Not frst Mon")
  15. Replies
    4
    Views
    91

    Re: VBA code to clear range and text box

    This should work.
    You've either not given the procedure a name, or only copied part of it into your post, so I've left the top part exactly as-is.
    MsgBox "Your email was sent." & vbNewLine & "The...
  16. Re: Wondering whether a formula could assist or is even possible ...

    Glad you're sorted, Sue.
    You should be over here now - first summer for years, when it's not rained most days! I'm even thinking of dusting off the old BBQ - just need to remember how to use it!
  17. Replies
    7
    Views
    123

    Re: Warning Message for non-zero check figures

    This needs to go into the Workbook module:
    Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
    If Sh.Name = "WS13" And Target.Address = "$D$3" And Target.Value <> 0 Then...
  18. Replies
    4
    Views
    91

    Re: VBA code to clear range and text box

    Where are these textboxes? on a worksheet (if so, what's the name of the sheet) or on a userform?
  19. Re: Wondering whether a formula could assist or is even possible ...

    Hi Sue

    Could be that Eric's busy / offline etc; in his absence, I suggest that you make a copy ("SaveAs") and mess around on that, if you're concerned about compromising the original data.
    You...
  20. Re: VBA to change tab colour using the palette

    If you were happy with 56 colours, then you could use a separate worksheet as your "Pallette" and, in the sheet's _selectionChange event temporarily use:
    Private Sub Worksheet_SelectionChange(ByVal...
  21. Replies
    14
    Views
    259

    Re: Help please - how to hide a macro button

    Right...
    Can you run this in your module 8 - ensuring that "Dashboard" is the active sheet, before doing so:
    Sub btn_names()

    Dim shp As Shape
    Dim str As String
    Dim sht_name As String
    ...
  22. Re: what is wrong with this single line of code (finding last row in a column)

    Try using range, instead of cells...
    Dim cntRows As Long
    cntRows = ActiveWorkbook.Worksheets("ANALYTICS").Range("F1").Find("*", , , , xlByRows, xlPrevious, , , False).Row

    Incidentally, if it's...
  23. Replies
    14
    Views
    259

    Re: Help please - how to hide a macro button

    It should also have given us a sheet name.
    What's the WHOLE string, when that code's run?

    The other question I'd asked in my previous post was, "Where is this procedure held?" i.e. in the sheet's...
  24. Replies
    14
    Views
    259

    Re: Help please - how to hide a macro button

    1. Is the worksheet which contains the button, actually active, when the code runs?
    2. Where is this procedure held?
    3. Can you ensure the sheet in question is the active worksheet, go into your...
  25. Replies
    4
    Views
    125

    Re: Pounds and Ounces subtraction formula

    This is a bit "schoolboy" but does the trick:
    In C1:
    ...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4