Search:

Type: Posts; User: Jaafar Tribak; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.29 seconds.

  1. Re: How to detect / bypass the Workbook Recovery window and process

    Have you tried setting the Document Recovery Pane visibility to False when launching excel from Word ?

    Something like this maybe :

    Dim oXl As Object

    Set oXl =...
  2. Re: How to access value and change events of Userform dropdown in another workbook

    See if you can adapt the following to your needs :

    https://www.mrexcel.com/forum/excel-questions/677098-accessing-userform-workbook-workbook-b.html
    ...
  3. Replies
    15
    Views
    586

    Re: [SOLVED] - Re: Remove all authors name from Excel

    Thanks for letting us know .

    Here is a webpage that explains how to handle the Windows Search Service Database File via the UI.
    https://windowsreport.com/windows-edb-file-huge-windows-10/
  4. Re: Is there any way to change range's values more efficiently than looping?

    Hi Rick, Well spotted !

    I didn't think about possible empty entries.

    @vonguyenphu

    I always search Rick Rothstein's posts when I have vba formulaes\string manipulations issues. I would...
  5. Re: Is there any way to change range's values more efficiently than looping?

    You are welcome.

    I don't know of a tutorial but a quick search came up with this discussion :...
  6. Re: Is there any way to change range's values more efficiently than looping?

    You mean like this :

    Range("A1:A1000") = Evaluate("=LEFT(" & Range("A1:A1000").Address & ",3)")

    Or amybe wrap the code in a seperate sub for more flexibility :

    Sub LeftWithoutLoop(ByVal R As...
  7. Replies
    8
    Views
    126

    Re: Populate Range from string

    Actually, a Userform is a Class with a user interface ... All that which applies to Classes also applies to userforms. Things like instanciation with the New keyword and defining Properties, Methods...
  8. Re: Is there any way to change range's values more efficiently than looping?

    Is that in a macro ? if so, this for example, should do what you want without the need for looping.


    Range("A1:A1000") = Evaluate("=LEFT(A1:A1000,3)")

    Change range address as required.
  9. Re: Enable Microsoft Scripting Runtime with vba within a Public Sub with Public Declarations

    If you just want to save time why don't you place the line in each of the 50 files open event :

    Private Sub Workbook_Open()
    Me.VBProject.References.AddFromGUID...
  10. Replies
    5
    Views
    171

    Re: Styles of programming in VBA

    Function MyFunc(somearg As Burger) As McDonalds


    Not necessarely just Classes. They could be any data structure such as Classes, Interfaces, UDTs and Enums.
  11. Replies
    6
    Views
    158

    Re: Insert a line break after word wrap

    You could use this hack : (should work with multi-line textboxes on userforms as well as in worksheets)


    1- In a Standard Module :

    Option Explicit


    Public Function...
  12. Re: A further 32 to 64 bit conversion problem

    Glad I could help
  13. Replies
    5
    Views
    118

    Re: highlight row and column

    Yes, it can be done with conditional formatting and\or vba ... there are plenty of examples out there ... just do a search on this site or on the web.
  14. Re: A further 32 to 64 bit conversion problem

    Try this :

    Option Explicit

    'This code was originally written by Dev Ashish.
    'It is not to be altered or distributed,
    'except as part of an application.
    'You are free to use it in any...
  15. Replies
    5
    Views
    99

    Re: Drag Picture on Userform

    Can you show us the code you are using ? Maybe if you could upload here a simplified test userform workbook so we can reproduce the issue you are describing
  16. Re: Showing cell text length while typing

    Sorry to disappoint you but after giving this a try it turned out to be more difficult than I initially thought.

    Certainly, one can call PeekMessage inside a loop and increment the counter each...
  17. Re: Showing cell text length while typing

    I think using the PeekMessage API and watching for the keystrokes might work even while in edit mode.

    Where do you want to see the resulting text length ?
  18. Re: VBA to check if circles are inside of freeform area or not

    LAST UPDATE.

    Note: Please ignore all the codes I published in my previous posts and use this one only.


    WORKBOOK DEMO

    New adjustements have been made for more accurate results and faster...
  19. Re: VBA to check if circles are inside of freeform area or not

    UPDATE

    The above code works well but fails if the current worksheet zoom is other than 100%... I had completely forgotten about the current zoom and how it would affect the final result.

    Anyway...
  20. Re: Cool RefEdit Alternative - (Made with a standard TextBox !)

    Hi,

    Glad you liked it and good luck with your project.
  21. Replies
    19
    Views
    27,399

    Re: How to change the UserForm Caption Font

    Hi Yasser - How are you .

    I'll take a look at this later on a different machine and will let you know.

    Regards.
  22. Re: VBA to check if circles are inside of freeform area or not

    Workbook Example

    Sorry for coming back on this so late. The reason being is that after further testings, the workaround I described in my previous post didn't work accurately enough.

    It is...
  23. Re: VBA to check if circles are inside of freeform area or not

    Hi Rick,

    If by "circles are inside of freeform area" the OP meant partly or Fully inside ( ie: intersection between freeform and circle is not nothing) then I have an API workaround which so far...
  24. Re: Cool RefEdit Alternative - (Made with a standard TextBox !)

    New Workbook Update.

    I would prefer leaving the Class Module code untouched and would just do the following:


    1- Add to the main API standard Module a new routine named :...
  25. Replies
    16
    Views
    440

    Re: Allow Access to Hidden Sheets

    Just set the font color of the cell to blue and underline the font from the Font menu.
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4