Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.02 seconds.

  1. Re: Change the line spacing between items in a VBA listbox

    Dear Mick,

    Many thanks for your quick help, code works great. However giving value 2 to "sp" takes too much space between month names (value 1 is the original spacing). So I'd need a value between...
  2. Change the line spacing between items in a VBA listbox

    Hi Guys,

    I'd like to change the line spacing between items in a VBA listbox. Let's assume I display month names in a listbox control. Name of my listbox is "Lista". It's easy, I just add one line...
  3. Replies
    19
    Views
    3,621

    Re: Extract Thumbnail preview from file

    Dear Jaafar,

    Works great on Windows 10 (64 bit) and Office 365 (32 bit).

    Many thanks for sharing.

    Kind Regards,
  4. Re: Cool Customized standard InputBox to allow validating input as you type in.

    Thanks for your honesty. On the one hand of course I accept it. On the other hand not :)

    As My Aswer Is This wrote:

    That's my opinion too. I have mixed feelings because your API-s are...
  5. Re: Cool Customized standard InputBox to allow validating input as you type in.

    Hi Jaafar,

    Works like a charm as well on Office 365 32 Bits/Win10 64 Bit. Thanks for sharing it, really awesome.

    Have you every thought about to start a blog/make short videos about basics of...
  6. Re: Cool Customized standard InputBox to allow validating input as you type in.

    Hi Jaafar,

    Works like a charm on Office 365 32 Bits/Win10 64 Bit. Thanks for sharing it.
    Have a great day/weekend.
    Kind Regards,

    KeepTrying
  7. Replies
    4
    Views
    303

    Re: Excel Tables - appropriate to use?

    Just to add as a disadvantage:

    It won't work if you protect the worksheet.

    Have a nice day.
    Kind Regards,
  8. Re: Determine if a workbook was opened by VBA code or by user

    Dear Jaafar,
    Thanks for you effort. As you pointed out code works except if....
    Userform shouldn't be necessarily modeless. I changed it to Modal but it still allows to open e.g. .xlsm file (even...
  9. Re: Determine if a workbook was opened by VBA code or by user

    Hi Jaafar,


    Yes, I confirm that.

    Thank you.
  10. Re: Determine if a workbook was opened by VBA code or by user

    Hi mikerickson,

    Thanks for your code it works like a treat but only if I do not run macro. If I run a macro and open another Excel file (e.g. from Windows Explorer) then new file opens in new...
  11. Re: Determine if a workbook was opened by VBA code or by user

    Dear mikerickson,

    Thank you so much for your advice. I'll consider your (and JazzSP8's) note as an alternative solution. I wrote earlier:

    But of course I can check those files in advance as...
  12. Re: Determine if a workbook was opened by VBA code or by user

    Dear Jaafar,
    Thanks a lot for dropping by :-) I wouldn't have thought this determination can be so complex.


    Workbooks - which are opened by userform - are not always the same but if you can...
  13. Re: Determine if a workbook was opened by VBA code or by user

    Bump
    Anyone please? Maybe it's possible to determine it with some nice API code?
  14. Re: Determine if a workbook was opened by VBA code or by user

    Hi JazzSP8,

    Thanks for your ideas. Necessary files are not fixed (e.g. use latest file in a folder). As mentioned "I want to prevent users to open a new/existing workbook while my macro is...
  15. Determine if a workbook was opened by VBA code or by user

    Hi Folks,

    It sounds simple but I couldn't find a proper way how to check if a workbook was opened by macro or by a user. To cut a long story short: I run a macro (it displays a userform) which...
  16. Replies
    15
    Views
    4,534

    Re: Force Macro - question

    dam*it. Anyway, thanks a lot for your effort and time.
  17. Replies
    15
    Views
    4,534

    Re: Force Macro - question

    Dear Jaafar,

    I know this is an old post but...
    I have same issue on Excel 2016/Windows 10. Is there any chance to have a look at this please?

    Thank you.

    Kind Regards,
  18. Re: Cool Excel Magnifying Glass to Zoom the entire Screen !

    Dear Jaafar,
    for info: I have same issue. I use Windows 10 (64 bit, Intel processor) and Excel 2016 (32 bit).
    Kind Regards,
  19. Replies
    11
    Views
    626

    Re: Excel Manufacturing inventory

    Any feedback please?
  20. Replies
    11
    Views
    626

    Re: Excel Manufacturing inventory

    Hi,
    I updated my code. You need to open VBE (ALT+F11) and double click on Sheet name then add code. E.g.:

    https://s13.postimg.org/3twvzpn07/Prt_Screen01.jpg




    Option Explicit
  21. Replies
    11
    Views
    626

    Re: Excel Manufacturing inventory

    Still not clear from the image what you want to achieve. Here is my understanding: see before and after print screens:
    https://s13.postimg.org/45ih6hwd3/Prt_Screen_Mr_01.jpg...
  22. Replies
    11
    Views
    626

    Re: Excel Manufacturing inventory

    Picture is not shown. You need to upload print screen to an image hosting site then share link here.
  23. Replies
    11
    Views
    626

    Re: Excel Manufacturing inventory

    Hi Chrisg33,
    I think a print screen would be useful about your sample data layout. I have an idea but I don't know how your data look like.
  24. Replies
    9
    Views
    210

    Re: Reformatting Data from 1:Many to 1:1

    Dear juxel,
    Another code for you to consider. Here you can select input and output range:



    Sub One_to_One()

    ...
  25. Re: Wordpress plugin to show VBA code snippet (syntax highlighter)

    Thanks a lot, I found this one:
    https://wordpress.org/plugins/crayon-syntax-highlighter/
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4