Search:

Type: Posts; User: Dan_W

Search: Search took 0.01 seconds.

  1. Replies
    4
    Views
    403

    Re: Grid-like Userform

    Here's one option. The code below:

    - dynamically creates 100 label controls (10 x 10);
    - creates a transparent 'Overlay' label control that is used to track the mouse location over the entire...
  2. Replies
    135
    Views
    2,385

    Re: LED.OCX & Windows 11 Pro

    For VBA, the relevant Excel.Application needs to have been instaniated in admin mode -...
  3. Re: [RESOLVED] Copying Conditional Formatting Details

    Out of curiosity, what were you trying to do? And how did you solve it?
  4. Thread: A Tooltips Class

    by Dan_W
    Replies
    4
    Views
    2,235

    Re: A Tooltips Class

    Thank you for this.
    Do you see any reason I wouldn't be able to rejig this to be compatible with VBA (64bit)? I note that the routine for setting the tooltips requires a control with a hWnd (or a...
  5. Replies
    2
    Views
    1,018

    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.
    ...
  6. 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!
  7. 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/
  8. Replies
    3
    Views
    402

    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:
    ...
  9. Replies
    7
    Views
    3,504

    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....
  10. Replies
    11
    Views
    853

    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,...
  11. Replies
    11
    Views
    853

    Re: PointsToScreenPixelsX

    This approach appears to work - here. It will work modelessly too.
  12. Replies
    11
    Views
    853

    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:...
  13. Replies
    20
    Views
    813

    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.
  14. Replies
    12
    Views
    771

    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.
  15. Replies
    12
    Views
    771

    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...
  16. Replies
    1
    Views
    559

    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...
  17. Replies
    16
    Views
    1,140

    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...
  18. 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...
  19. Re: [Add-In] Large Project Organiser (alternative Project Explorer)

    Thank you very much! :-)
  20. Replies
    8
    Views
    727

    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,...
  21. Replies
    8
    Views
    727

    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...
  22. Re: Formula - Keep destination formatting

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

    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?
  24. Replies
    10
    Views
    926

    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...
  25. Replies
    10
    Views
    926

    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...
  26. Replies
    14
    Views
    8,176

    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...
  27. Replies
    14
    Views
    8,176

    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...
  28. Replies
    7
    Views
    753

    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 =...
  29. 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...
  30. Replies
    25
    Views
    2,782

    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...
  31. Replies
    25
    Views
    2,782

    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...
  32. Replies
    7
    Views
    1,619

    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 32 of 32



Click Here to Expand Forum to Full Width