Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.21 seconds.

  1. Replies
    6
    Views
    156

    Re: Screwing up a nested IF function

    Thanks for letting us know and you're welcome :)
  2. Replies
    6
    Views
    156

    Re: Screwing up a nested IF function

    Hi Merlin,

    Try this:

    =IF(D15<=200,25,IF(AND(D15>=201,D15<=399),50,100))

    Regards,

    Robert
  3. Re: VBA to Concatenate across multiple workbooks

    Hi Tooflychicken,

    Welcome to MrExcel!!

    Try this (just change the setting of the two variables I marked as 'Change to suit'):


    Option Explicit
    Sub Macro1()
  4. Re: Need Autofilter for more than 2 criteria - Array is not working

    Thanks Peter. I suppose another option for my code would be to paste rngFiltered on another tab.

    Can you build and append to a custom view?

    How's the drought in Macksville?
  5. Re: Need Autofilter for more than 2 criteria - Array is not working

    Hi Peter,

    I'm curious. I've written the following code to set a range that meets the user's requirement but don't know how to filter using it as the source - can you show me how:


    Option...
  6. Re: Need Autofilter for more than 2 criteria - Array is not working

    It works for me :confused:

    Your code uses "Activesheet" so make sure you're on the tab in question before running. The other possibility is that the tab is protected.

    Robert
  7. Thread: for each loop

    by Trebor76
    Replies
    14
    Views
    404

    Re: for each loop

    Thanks Fluff. So annoying when people do that.

    I'm out of this thread now.
  8. Thread: for each loop

    by Trebor76
    Replies
    14
    Views
    404

    Re: for each loop

    If there's a cell formula error like #N/A the code will return this error.
  9. Thread: for each loop

    by Trebor76
    Replies
    14
    Views
    404

    Re: for each loop

    Not sure as it worked for me :confused:

    Ensure what the strMyCtrl is returning is an actual control name on the form.
  10. Thread: for each loop

    by Trebor76
    Replies
    14
    Views
    404

    Re: for each loop

    OK try this (though I don't think you can have more than one radio button selected):


    Option Explicit
    Private Sub awp()

    Dim rngMyCell As Range
    Dim strMyCtrl As String
    Dim ws...
  11. Thread: for each loop

    by Trebor76
    Replies
    14
    Views
    404

    Re: for each loop

    So you changed my code to work?
  12. Re: Active sheet, text box copy, check if cell empty

    Thanks for letting us know and you're welcome :)
  13. Re: VBA code that returns a unique list of non consecutive items, for a lookup value from a table

    Here's a VBA method of my procedure in thread 3:


    Option Explicit
    Sub Macro1()

    Dim lngMyCol As Long

    lngMyCol = 1 'i.e. Col. A
  14. Thread: for each loop

    by Trebor76
    Replies
    14
    Views
    404

    Re: for each loop

    No problem and you're welcome :)

    Have a look here about what I meant re type of control.

    Regards,

    Robert
  15. Re: VBA code that returns a unique list of non consecutive items, for a lookup value from a table

    The following three steps will also produce a list of unique entries (best from Excel 2010):

    1. Highlight the column with the data (Col. A in your case)
    2. From the DATA ribbon select Remove...
  16. Re: Active sheet, text box copy, check if cell empty

    Hi mrmrf,

    Here's one way:


    Option Explicit
    Private Sub AddButton2_Click()

    If Len(Range("N15")) = 0 Then
    Range("N15").Value = Me.txtSampleNo.Text
  17. Thread: for each loop

    by Trebor76
    Replies
    14
    Views
    404

    Re: for each loop

    That doesn't answer my question :confused:

    Controls (in your case a worksheet radio button control) can either be a Form or ActiveX control. The code to set each is different. The following...
  18. Thread: for each loop

    by Trebor76
    Replies
    14
    Views
    404

    Re: for each loop

    What control type have you used for your "ob" controls - i.e. Form Controls or ActiveX Controls?
  19. Re: Pop up message when numbers 1, 2, 3 or 4 are entered into entire columns AI through AV

    You will need to use another event. To save duplication put this macro into a standard workbook module...


    Option Explicit
    Sub MessageDisplay(lngMyNum As Long)

    Select Case Val(lngMyNum)...
  20. Re: Pop up message when numbers 1, 2, 3 or 4 are entered into entire columns AI through AV

    Hi discoveringexcel,

    Welcome to MrExcel!!

    Try this event macro* on the sheet in question:


    Option Explicit
    Private Sub Worksheet_Change(ByVal Target As Range)
  21. Re: Delete rows if cell value is greater than a specific time

    Thanks for letting us know and you're welcome :)
  22. Re: Delete rows if cell value is greater than a specific time

    Hi Rackette,

    Try this while on the sheet with the data (though initially on a copy of your data as the results cannot be undone if they're not as expected):


    Option Explicit
    Sub DeleteRows()...
  23. Re: Solution not needed - just clarity on a piece of this code!

    You're welcome. Glad it helped :)
  24. Re: Solution not needed - just clarity on a piece of this code!

    You only want to have a single range for ease of output in this case. If you introduce a second range you'll probably have to initially set it and then use UNION to append it. Seems double handling...
  25. Re: Solution not needed - just clarity on a piece of this code!

    I'm not too sure what you mean or what you're after (is ABC a range variable??) but here's another slightly different way to do the same that I wrote with some notes (hope it helps):


    Option...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4