Search:

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

Page 1 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    11
    Views
    10,659

    Re: RGB contrast COLOR Formula

    I've just found this very useful function from 2011 Rick and it's just what I was looking for.

    Thanks.
  2. Replies
    7
    Views
    253

    Re: BuiltIn Dialog Boxes

    It is this that works :

    Application.CommandBars.ExecuteMso "FormatCellsFontDialog"


    I also found this page that just so happens to be on dummies.com!!!
    ...
  3. Replies
    7
    Views
    253

    Re: BuiltIn Dialog Boxes

    I am getting a 'Type Mismatch' error with this

    Application.Dialogs(strDialogBox).Show

    and an 'Invalid Procedure Call Or Argument' error with this

    Application.CommandBars.ExecuteMso...
  4. Re: For each loop is working for only first item in a range

    Hi

    Replace

    For Each MyCell In [B4:B18]

    with

    For Each MyCell In Range("B4:B18").Cells
  5. Replies
    7
    Views
    253

    BuiltIn Dialog Boxes

    Hi

    I'd like to load Excel BuiltIn Dialog Boxes by using the following line of code or similar and where the strDialogBox variable contains the
    name of the Dialog Box to load.
    ...
  6. Re: Creating Userform Controls At Runtime

    Hi Jaafar

    That works fine, thank you very much.

    I assume that I will need to insert a Private WithEvents declaration line for each control created and that works fine unless there is a way...
  7. Re: Creating Userform Controls At Runtime

    If you paste this code into the form module and load the form. The form is to be called frmUserForm.

    The 'Test' button will not work when you first load the form but load it again and it will...
  8. Creating Userform Controls At Runtime

    Good morning

    I am adding controls at runtime to a userform.

    I have done this before and I cannot work out what I am doing differently this time.

    I can add the controls alright and I can add...
  9. Subtracting time to produce time in previous day.

    Hi

    I would like to be able to subtract a combination of hours, minutes and seconds from a date and time.

    The resultant time may be in the previous day and that is where the problem is.

    For...
  10. Replies
    3
    Views
    173

    Re: Named Range Name in Cell Formula

    This was how I was doing it but the named range needs to be hard coded into the formula.

    I wanted to find a way in which the name of the named range can be arrived at by evaluating an expression. ...
  11. Replies
    3
    Views
    173

    Named Range Name in Cell Formula

    Hi

    Whilst I have a get around solution to this problem I wondered how others may implement the problem.

    I want to refer to one of two named ranges in a formula using the RANK function in a...
  12. Replies
    2
    Views
    171

    Deselecting selected listbox item.

    Happy New Year Everybody

    I'm not quite as happy as I would like to be but if someone can help me sort this teaser out I'll be on my way....

    I select an item in a listbox and then run some code....
  13. Replies
    3
    Views
    289

    Re: Activating workbook from userform

    Got there in the end.

    https://www.jkp-ads.com/articles/keepuserformontop02.asp

    Not quite as simple as I think that it should be. Prior to 2013 Excel kept the userform on top.
  14. Replies
    3
    Views
    289

    Re: Activating workbook from userform

    Activating a workbook other than the one that the userform is in works fine but I want the userform to still be displayed on top of the active sheet.

    It should be so simple as I imagine that it is...
  15. Replies
    3
    Views
    289

    Activating workbook from userform

    Hi

    I am loading a userform from workbook1 which contains code behind a command button to select another workbook (workbook2)
    and load it.

    I want the active workbook to be workbook1 but...
  16. Replies
    2
    Views
    206

    Re: Cann view the VB Editor

    ALT-F8 works fine but I cannot Edit or Run any of the macros.

    Reboot and creating new workbooks does not solve the problem.

    This is in Version 2016, all works fine in 2016 (Outlook 365)
  17. Replies
    2
    Views
    206

    Cannot view the VB Editor

    I have loaded Excel for the nth time today and I cannot now access the VB Editor.

    I have the Excel and VB tabs visible.

    Mouse depress on the VB tab causes the active cell highlighted border to...
  18. Re: Incorrect selection of listbox item on underlying userform.

    If I put a MsgBox as the last line in the cmdSelectClub_Click event procedure in the frmRiders module the problem is solved.

    Another way is to position the frmSelectClub form away from the...
  19. Replies
    7
    Views
    365

    Re: Nested if formula?

    Create a range called 'Locations' into which you list the 10 locations. This range can be on a hidden sheet.

    =IF((AND(E16>=100, E16<=199,COUNTIF(Locations,F16)>0)), "Freight In", IF((AND(E16>=300,...
  20. Re: Incorrect selection of listbox item on underlying userform.

    That change is not making any difference.

    Do you see what the problem is MickG?

    Does the change that you have suggested make a difference to how your copy works?

    Cheers
  21. Re: Incorrect selection of listbox item on underlying userform.

    I have created a stand alone example of this problem.

    https://www.dropbox.com/s/27h4bddlngpleqy/DropboxForms.xlsm?dl=0

    Please open the form 'frmRiders' and click on the 'Club' button to...
  22. Replies
    3
    Views
    230

    Re: Ways to measure Silo tonnage

    This looks like you have 9545.454545 kgms per metre depth.

    This is 95.45454545 kgms per centimetre.

    So just subtract the length of the dip in cms from 1200 and multiply by the 95.45454545.
    ...
  23. Re: Incorrect selection of listbox item on underlying userform.

    Not linked at all but this only happens when the selected item in the listbox on the 'frmSelectClub' is directly over one of the items in the listbox on the 'frmRiders' form. If the items do not...
  24. Incorrect selection of listbox item on underlying userform.

    Hi All

    I have a form 'frmRiders' which has a Command Button to load another form, 'frmSelectClub' from which one can select the club, using a listbox, to which the rider belongs.

    The name of...
  25. Replies
    1
    Views
    162

    Time textbox on userform

    Hi All

    I am trying to implement a textbox on a form that enables a user to enter a time e.g. 070000. Once I can do that i will try to allow colons in the appropriate places.

    In the first phase,...
Results 1 to 25 of 80
Page 1 of 4 1 2 3 4