Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.03 seconds.

  1. Re: I want to control the order of cell selection during data entry.

    Maybe E3 is locked?
  2. Replies
    5
    Views
    134

    Re: Adding Error with Copy & Paste

    Hi there. As the copy is done outside, you can't just use the paste function. Have a look at this reference to see how to read the contents of the clipboard - it also shows you how to handle empty...
  3. Re: How to autopopulate a textbox linked to a cell

    Try this:

    Private Sub UserForm_Initialize()
    Dim DateStr As String
    Dim ResultStr As String
    DateStr = Worksheets("Data").Range("B1").Text
    ResultStr = Right(DateStr, 1)
    For i = Len(DateStr) - 1...
  4. Re: How to autopopulate a textbox linked to a cell

    Glad to hear it worked. I assume B1 has in it something like "16/09/2019" but I'm still unclear on exactly what you want to see. Do you mean that you want to see (in textbox1) something like this:
    ...
  5. Re: How to autopopulate a textbox linked to a cell

    Hi there. You need to put the code that inserts the value in the userform initialize subrutine like so:


    Private Sub UserForm_Initialize()
    Me.TextBox1.Text = Worksheets("Data").Range("B1").Value...
  6. Replies
    5
    Views
    134

    Re: Adding Error with Copy & Paste

    If this is your code as typed (i.e. you haven't chopped out any lines from the middle) then your problem is because you have the error code directly after the paste statement, so it will always be...
  7. Replies
    3
    Views
    98

    Re: adding subquery in insert into

    Yeah silly me. Again untested:

    "insert into temp_cost(RecordID,ClassID, Classtype, ClassName, TypeOrder, CreateDate) values('" & strRecordID & "', (select classid from employee where...
  8. Replies
    19
    Views
    235

    Re: Code numbering invoice

    Abdel, this is because you are using Dave's solution, which relies on formatting of the cell to show you the prefix. A combined version of my solution in post #2 and Dave's will work.


    Private...
  9. Replies
    19
    Views
    235

    Re: Code numbering invoice

    abdel. If you use my solution in post #2 you will get the full text in your userform
  10. Replies
    19
    Views
    235

    Re: Code numbering invoice

    abdel. Where are you putting the code we have provided (either solution works, mine fills the f9 cell with the full text, Dave's with just the number? You would need to refresh the data in the...
  11. Re: Search and return lowest value (sounds easy but it's trickier than it sounds)

    OK I have read your revised rules. See if this does it for you (a total of less than 5 of any NAT values will result in 5@3)

    ...
  12. Re: Search and return lowest value (sounds easy but it's trickier than it sounds)

    Hi there. This formula in I2 and copied down will produce the output you show:

    ="5@"&MIN(IF(COUNTIF(C2:H2,"NAT3")>0,3,99),IF(COUNTIF(C2:H2,"NAT4")>0,4,99),IF(COUNTIF(C2:H2,"NAT5")>0,5,99))
    ...
  13. Replies
    19
    Views
    235

    Re: Code numbering invoice

    Hello. If your numbering always ends with the number you want to add to, then this will do it. Replace the bsjd- with another text if necessary.

    Dim Prefixtext As String
    Prefixtext = "bsjd-"...
  14. Replies
    1
    Views
    94

    Re: Create Loop for each row in a column

    Hi there. This is completely untested, but should work:

    Sub Add_Record()


    Application.ScreenUpdating = False


    Dim db As database
    Dim rs As DAO.Recordset
  15. Replies
    3
    Views
    98

    Re: adding subquery in insert into

    This is completely untested, but try
    "insert into temp_cost(RecordID,ClassID, Classtype, ClassName, TypeOrder, CreateDate) select ('" & strRecordID & "', (select classid from employee where...
  16. Replies
    4
    Views
    165

    Re: Run vba by clicking shapehyperlink

    Hi there. Try removing the IF clause, so the line:

    If rngReference.Rows("2:5").EntireRow.Hidden = False Then rngReference.Rows("2:5").EntireRow.Hidden = True

    becomes:
    ...
  17. Thread: Countif

    by jmacleary
    Replies
    8
    Views
    162

    Re: Countif

    Hi there. Try this:


    <code>=SUMPRODUCT(LEN(A:A)-LEN(SUBSTITUTE(A:A, ";","")))</code>
  18. Replies
    5
    Views
    179

    Re: setting cell to equal cell below

    Hi there. This code looks upwards in column A and if any blank is found, the row below (either just column A or the whole row depending on which line you leave in of my 2 commented lines) is copied...
  19. Re: Count the number of workers by 15 minute interval

    You're welcome and thanks for the feedback.
  20. Re: Count the number of workers by 15 minute interval

    Hi there. Your problem arises from the fact that excel doesn't handle decimal values precisely. If you look at the table below, you will see that some fractions of a day can be calculated exactly,...
  21. Re: Mixing Advanced Filters and Normal Filters

    Hi there and welcome. I suggest you add the ordinary filter criteria into the advanced filter.
  22. Re: Removing everything outside brackets in a cell

    OK sounds like youre going my route with 2 replaces. For the first replace you want to replace anything followed by an open bracket with just an open bracket. This is done by entering *( in the...
  23. Re: Removing everything outside brackets in a cell

    Another minor comment - my solution replaces the data in situ, both the others require the formula to be in a separate cell. If you want to keep the brackets my solution can be modified the use a...
  24. Re: Removing everything outside brackets in a cell

    Hi there. You can do it with 2 replaces. First, replace "*(" with nothing (leave the replace text blank). The replace ")*" in the same way. If you are wanting to do this many times, just record...
  25. Re: Custom List for Sort Order - Using Sorted Values w/ Commas

    What about recording/writing (depending on your vba skills) a macro to do those 10 steps?
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4