Search:

Type: Posts; User: Dan_W

Search: Search took 0.01 seconds.

  1. Replies
    2
    Views
    809

    Re: Using Google Translate

    I'm familiar with that routine - John_w (an MVP) wrote it. But the version above is different to what (I think) is his most recent version - as of Sept 2021.
    ...
  2. Re: Creating a new template and a beautiful user interface

    I can't thank you enouh for archiving it (and to Tanner for putting it on Github) - it's currently my primary resource in my GDI/GDI+ studies!
  3. Re: Creating a new template and a beautiful user interface

    You could also check out Leandro Ascierto's blog generally, but his posts on skins for Forms specifically: http://leandroascierto.com/blog/category/skins-para-formularios/
  4. Replies
    3
    Views
    250

    Re: [RESOLVED] Form Move

    Hi. It may not be entirely on point, but I wonder if the VBA code at the folllowing link might be of help:
    ...
  5. Replies
    7
    Views
    3,210

    Re: Control Array for VBA Controls

    Thank you for this - and, in particular, for the comments:


    Dim frmTheParent As IUnknown ' Declaring as UserForm doesn't allow CallByName.

    This, for example, has been extremely helpful....
  6. Replies
    11
    Views
    574

    Re: PointsToScreenPixelsX

    I made an array(1 to 4) of a basic userform, and it cycled through each of them each time I clicked on a certain cell, repositioning the relevant UserForm to be offset(0, 1) from the selected cell,...
  7. Replies
    11
    Views
    574

    Re: PointsToScreenPixelsX

    This approach appears to work - here. It will work modelessly too.
  8. Replies
    11
    Views
    574

    Re: PointsToScreenPixelsX

    There is a Userform positioner on Chip's site somewhere that does (from what I can gather) exactly what you're after: http://www.cpearson.com/Excel/FormPosition.htm

    [Edit] Found the link:...
  9. Replies
    20
    Views
    654

    Re: Vb6: richtextbox read line by line on click

    When you say "i have used this code, it works for msgbox", can you please share the working code too. It might help in working out the source of the problem.
  10. Replies
    12
    Views
    606

    Re: Converting VB6 add-in

    VBA doesn't compile DLL files. For that, you could try using TwinBasic which I've started exploring and looks very promising.
  11. Replies
    12
    Views
    606

    Re: Converting VB6 add-in

    In trying to improve in VBA, I end up converting projects written in VB6 to VBA fairly frequently. It really all depends on what it is that you add-in tries to do. If it's just a matter of converting...
  12. Replies
    1
    Views
    508

    Re: VBA Combine PNG/JPG to an animated Gif

    When you say you want to combine PNG/JPG files to an animated GIF, do you mean that you want to add each of the PNG/JPG images to an existing animated GIF as separate frames? Or that you what to...
  13. Replies
    16
    Views
    1,026

    Re: Using Word dictionary for spell check

    I wonder if perhaps you're code is referencing the wrong Word library (i.e., I'm using the Word 16.0 Object Library), but then I would expect an different error message/problem. What does your code...
  14. Re: [Ppt] How to execute commandbar control for triangle and double arrow?

    Not sure how to go about adjusting the commandbars enabled property for either shape, but hopefully the following VBA code will work for you. If you paste them in a standard module, you should then...
  15. Re: [Add-In] Large Project Organiser (alternative Project Explorer)

    Thank you very much! :-)
  16. Replies
    8
    Views
    677

    Re: Error while adapting VBA code

    Your most code snippet will result in the 438 error for the same reason - like ActiveDocument, Selection is a member of the Application (and not of the Document).
    Referring to your original code,...
  17. Replies
    8
    Views
    677

    Re: Error while adapting VBA code

    I tried it in VBA, and the line of code in question (as provided by you) did not work for me, but I didn't expect it to either.
    As westconn1 explained, Wdoc is itself a Document, and ActiveDocument...
  18. Re: Formula - Keep destination formatting

    Sounds as though the destination cell has conditional formatting applied to it.
  19. Replies
    10
    Views
    862

    Re: i need to make 3d viewer

    Well the website is, yes, but the projects that were on it have been reuploaded onto Github here. Did you not the see I link I posted?
  20. Replies
    10
    Views
    862

    Re: i need to make 3d viewer

    The author of the project, Peter Wilson, has a number of other 3D/Graphics projects on PSC, including some tutorials - so if the 3D Studio doesn't fully meet your needs, maybe the rest of PW's...
  21. Replies
    10
    Views
    862

    Re: i need to make 3d viewer

    By no means is it on the same level as The Trick's demo above, but there is a 3D Studio project will imports .X files (which I understand you were after from you other thread) available on Github...
  22. Replies
    14
    Views
    7,889

    Re: [VB6/VBA] Timer class.

    My apologies for the late reply - it's been hectic at work.

    The Trick - thank you very much for offering to look at my code. Given MountainMan's explanation re: EBMode, I don't want to waste your...
  23. Replies
    14
    Views
    7,889

    Re: [VB6/VBA] Timer class.

    @MountainMan - I've also can't seem to get the timer to decouple from the modal UserForm (Office 365/64bit) - I don't suppose you've managed to solve this? I've tried relocating the m_cTimers...
  24. Replies
    7
    Views
    710

    Re: Accessing data in Excel

    Hi

    In addition to the comments above, the Range reference is problematic:- Range(row & "A") would equate to cell 3A, rather than A3, for example.

    The following should work:


    Set ExcelApp =...
  25. Re: Marking an excel file with a key from system

    The suggestions above are likely the most straight-forward (and to easy to implement) solutions, but I thought I'd just throw into the mix the method detailed in Chip Peason's blog about writing and...
  26. Replies
    25
    Views
    2,604

    Re: How Recognize geometric shapes

    I was wondering the same thing. I wanted to ask OP, but he has been a bit quiet today since it became apparent I wasn't just going to do his assignment for him...! :-)
    My reason for being curious...
  27. Replies
    25
    Views
    2,604

    Re: How Recognize geometric shapes

    This is bizarre - I was helping someone else on a very similar 'problem' just this morning.

    I've been helping out on some Office/VBA forums by answering questions, etc., and was this morning...
  28. Replies
    7
    Views
    1,498

    Re: Calculator Simple usercontrol

    I ought to say that, for my part, I am extremely grateful to you and others who continue to share your work in the Codebank. I must confess that I don't have VB6, but I do code in VBA so I can...
Results 1 to 28 of 28



Click Here to Expand Forum to Full Width