Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Re: For each loop is working for only first item in a range

    Kelly_Mort: now your need is clear for me. I've noticed that fluff already helped you with the code which sounds good. I'm happy for you and glad we could help you. Thans for a feedback.
  2. Replies
    21
    Views
    760

    Re: get value from cell in a range

    Hi,
    You can also try this own-developed function which is the previous one extended by verification if.for.some reason value in the provided range is not a date format too.


    Function...
  3. Replies
    21
    Views
    760

    Re: get value from cell in a range

    Hi,
    I just found out I made a mistake in the own developed function I provided you with. Here's the function fixed. Pls check it now


    Function GetId(IdRange as range) as string
    Dim rCell as...
  4. Re: How to detect Userform 'X' or Cancel click from sub that loaded it

    You're welcome!
    You're right I misspelt it, of course, should be vbFormControlMenu :)
  5. Re: For each loop is working for only first item in a range

    Hi,
    My recommendation is you right what you exactly expect from algorism to be done. How the code should work? Based on that I can offer you fixing/writing down the code adjusted to your needs.
    In...
  6. Re: Date validation error - Unable to set the NumberFormat property of the Range class

    Hi,
    The code in my opionion is OK. It's works on my laptop. So my question is whether your worksheet/workbook is protected? Perhaps you might upload your file to dropbox in order to have a look into...
  7. Re: For each loop is working for only first item in a range

    Hi,
    Get a rid of exit for when the following comdition is true


    If MyInput = MyCell Then
    'Get a rid of exit for here
    Else

    End if
  8. Re: How to detect Userform 'X' or Cancel click from sub that loaded it

    Hi
    Declare public parameter
    Publuc bool_ClosedByControl as boolean (declare it above the sub!)
    At the beginning of your sub, before for statement set it to false, bool_ClosedByControl=false...
  9. Replies
    9
    Views
    194

    Re: Hide Unhide Rows

    Hi,
    Exactly, this is what I was asking about. Here you have the code. Paste it worksheets 2 (not in the module). :)


    Private Sub Worksheet_Change(ByVal Target As Range)
    Dim ws as worksheet
    Set...
  10. Re: How to have user select which worksheets to run macro on

    My pleasure. I'm glad you've made it & thanks for your feedback :)
  11. Re: Adding Date Range Criteria to If Statement

    Hi,
    What do you want to achieve? You want to return value from column C if all the following conditions are met:
    max in col E = value U2 and max in col B = value B7 and date in col D is between...
  12. Replies
    21
    Views
    760

    Re: get value from cell in a range

    Hi,
    I recommend you upload your file with test data on dropbox in order to have a better overview of what you have and check how to help you. What do you reckon?
  13. Re: adding text to two different cells and highlighting row

    My pleasure. Thank you for a feedback :)
  14. Re: How to have user select which worksheets to run macro on

    Hi,
    You can use list box instead plus multiselection option. Within Listbox you can process multiselection :). Once user selects worksheets you have to check which options are selected using...
  15. Replies
    9
    Views
    194

    Re: Hide Unhide Rows

    You do not get me I suppose.
    In order to hide/unhide rows 2:10,10:15 I need to know which cell or range of cells I need to check if user types in yes or no value but you have not provided me with...
  16. Re: How to have user select which worksheets to run macro on

    Hi,
    It comes to my mind two options:
    1. Make the code so it works on activesheet only and before updating ask user by msgbox for the decision if to run the macro on the active worksheet
    2. Create...
  17. Replies
    9
    Views
    194

    Re: Hide Unhide Rows

    User tyoes yes or no in one cell is that right?
  18. Re: vba Remove last 5 characters from string in table column

    Hi,
    How about this approach?



    Sub New_Patient()
    Dim rng as range
    Dim sh as worksheet
    Dim rCell as range
    Set sh=worksheets(1)
  19. Replies
    9
    Views
    194

    Re: Hide Unhide Rows

    Hi,
    I need you provide more information. What do you mean by whenever? What is the range the algorism should chech the yes/no value?
  20. Re: VBA - Delete rows that DO NOT contain Bold font

    Hi again,
    One more thing about my code I forgot to mention. If you have more than 2 columns you have to extend if from 2 to as many conditions as column you have.
  21. Re: VBA - Delete rows that DO NOT contain Bold font

    You're welcome!
    With my approach you need to set first header column no which I set to 1, header row no which I also set to 1 and offset(0,1) which I set to one because I assume you have two...
  22. Replies
    15
    Views
    622

    Re: Traffic light warning system

    Hi,
    Thanks for the file. I've checked that and do as follows:
    1. Get a rid of *0,1 from formulae '
    =J9/G9*0,1' in cel K9 because the percentage should be calculated j9/G9
    2. Go to the conditional...
  23. Re: Date validation error - Unable to set the NumberFormat property of the Range class

    Hi,
    Try this




    Private Sub ValidateDate(r As Range)


    Dim c As Range
  24. Re: VBA - Delete rows that DO NOT contain Bold font

    Hi,
    You can also try this.



    Sub DeleteNotBold()
    Dim headerColumn&
    Dim headerRow&
    Dim lastRow&
    Dim i&
  25. Replies
    2
    Views
    133

    Re: Countifs with Count blanks with formula

    Hi,
    To count empty cells try this.


    =COUNTIFS(A2:A100,=&"")
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4