Working with ListBox Control in Excel VBA

Поділитися
Вставка
  • Опубліковано 27 сер 2024

КОМЕНТАРІ • 68

  • @kingsoko5319
    @kingsoko5319 Рік тому +1

    Very creative 🙂 Thanks 🙏

    • @VBAA2Z
      @VBAA2Z  Рік тому

      Thank you! Cheers!

  • @user-rx2ei2uu8q
    @user-rx2ei2uu8q Рік тому

    Thank you for very informative tutorials.

    • @VBAA2Z
      @VBAA2Z  Рік тому

      Glad it was helpful!

  • @roland9923
    @roland9923 3 роки тому +1

    Excellent as always, learned many out of box functionality

  • @holieh5301
    @holieh5301 3 роки тому +1

    Nice work Pamai. Thanks for making many projects available for free

    • @VBAA2Z
      @VBAA2Z  3 роки тому

      My pleasure 😊

  • @carlo9567
    @carlo9567 Рік тому +1

    Outstanding !

  • @adrianl6409
    @adrianl6409 3 роки тому +1

    Another excellent tutorial thank you so much Pamai

  • @MuhammadShahAlam99
    @MuhammadShahAlam99 Рік тому

    Good Job👍
    Suppose, we took another column (Remarks column) and took a TextBox. After selecting 8-9 data from the Listbox, whatever I write in the textbox will be added to that column.

  • @hoseal8048
    @hoseal8048 3 роки тому +1

    Thanks for another practical video

    • @VBAA2Z
      @VBAA2Z  3 роки тому

      You are welcome!

  • @SaraPerzYT
    @SaraPerzYT 3 роки тому +1

    Sir your videos are very relevant. Keep going thanks

    • @VBAA2Z
      @VBAA2Z  3 роки тому

      Thank you, I will

  • @luiscarlosbermudezjaramill5842
    @luiscarlosbermudezjaramill5842 3 роки тому +1

    Excelente video

    • @VBAA2Z
      @VBAA2Z  3 роки тому

      thank you!

  • @sunnylokesh3500
    @sunnylokesh3500 3 роки тому +1

    👍👍 extremely helpful and relevant. Many thanks

    • @VBAA2Z
      @VBAA2Z  3 роки тому

      You're very welcome!

  • @gregorytaylor2749
    @gregorytaylor2749 3 роки тому +1

    Great teaching video. Thanks!

    • @VBAA2Z
      @VBAA2Z  3 роки тому

      You are welcome!

  • @davidvyskocil9132
    @davidvyskocil9132 3 роки тому

    Awesome as usual, thanks...

    • @VBAA2Z
      @VBAA2Z  3 роки тому

      My pleasure!

  • @scottansir7708
    @scottansir7708 3 роки тому +1

    brilliant as always

    • @VBAA2Z
      @VBAA2Z  3 роки тому

      Glad you enjoyed it

  • @kinga334
    @kinga334 3 роки тому +1

    Keep up the good work. Many thanks

    • @VBAA2Z
      @VBAA2Z  3 роки тому

      Thanks, will do!

  • @matnz7546
    @matnz7546 3 роки тому +1

    Thanks for very informative tutorials.
    Please demonstrate how to pull this list from database instead of excel? Thanks in advance

    • @VBAA2Z
      @VBAA2Z  3 роки тому

      Great suggestion!

  • @pekidonn5139
    @pekidonn5139 3 роки тому +1

    Nicely put together. Keep it up cheers!

    • @VBAA2Z
      @VBAA2Z  3 роки тому

      Thank you! Cheers!

  • @excel2kit
    @excel2kit 3 роки тому +1

    Nice video

  • @HarshlyHarshly-fs9sn
    @HarshlyHarshly-fs9sn Рік тому

    great work thanks!

    • @VBAA2Z
      @VBAA2Z  Рік тому

      You're welcome!

  • @lchewang6512
    @lchewang6512 3 роки тому +1

    thanks for another amazing video

    • @VBAA2Z
      @VBAA2Z  3 роки тому

      Glad you enjoyed it

  • @jaredkulavich6081
    @jaredkulavich6081 3 роки тому +1

    thanks!

  • @m-squaredcontractors9720
    @m-squaredcontractors9720 3 роки тому +1

    Thank you for the great tutorial. I have a question not sure if you covered that in your other tutorials. How do I align data on a 2 column listbox for example left align column 1 and right align column 2?

    • @VBAA2Z
      @VBAA2Z  3 роки тому

      Sorry, the short answer is no you can't align individual columns.
      try ListBox

  • @efernandes67
    @efernandes67 3 роки тому

    Excellent tutorial Pamai. Can you tell me if its possible to have triple state on a listbox with a MultiSelect = fmMultiSelectMulti and ListStyle = fmListStyleOption? If not how can it be done?

  • @sensational4459
    @sensational4459 3 роки тому +1

    How to select list box from keyboard button once list box is shown below text box.

    • @VBAA2Z
      @VBAA2Z  3 роки тому

      Up Down Arrow key
      Space key to select

    • @sensational4459
      @sensational4459 3 роки тому

      @@VBAA2Z I tried it did not select

    • @VBAA2Z
      @VBAA2Z  3 роки тому

      @@sensational4459 ensure properties multiselect is set to 1-fmMultiSelectMulti

  • @Husky_Passion
    @Husky_Passion 3 роки тому +1

    the very bad thing with listbox, is they cannot be made transparent, they nearly show as if a frame and it's super anoying to make a transparent list.
    Couldn't find an api to do it, so usually i use a textbox but it's super anoying to simulate a listbox

    • @VBAA2Z
      @VBAA2Z  3 роки тому

      transparent feature would have been great.

  • @lordkailon
    @lordkailon 3 роки тому

    Hi There!!!, Great vídeos. Quesitos???,
    Can you send multiple emails from a listview or a listbox of a userform?

    • @VBAA2Z
      @VBAA2Z  3 роки тому

      Yes you can! check out below for email automation related videos.
      ua-cam.com/play/PLo0aMPtFIFDprmb4MBozLAdCn3-1cnnDA.html

  • @haider236
    @haider236 2 роки тому

    Is it possible to change the background clolor of listsubitem rows as mod 2

    • @VBAA2Z
      @VBAA2Z  2 роки тому

      There is no back color property however you can set background using picture property

  • @atingnewmai3680
    @atingnewmai3680 3 роки тому +1

    👍

  • @anhnhatnguyet4628
    @anhnhatnguyet4628 3 роки тому +1

    I have a word file of 300 pages. every 3 pages will be 1 section (pages 1 to 3, 4 to 6, 7 to 9, .....). now I want to use vba to print each section so that when printing, each section contains 3 pages. that is, page 4 is not merged on page 3 for 2-sided printing. same for page 7 and page 6. page 10 and page 9 ..... hope you support me

    • @VBAA2Z
      @VBAA2Z  3 роки тому

      Try posting in msdn or stackoverflow experts there will be able to assist sooner.
      please check if this video helps under work objects better. ua-cam.com/video/RQgOxv6nrE0/v-deo.html

  • @debbie6085
    @debbie6085 3 роки тому

    Thanks Lung. Great video.
    I looked for the link to download the source code but couldn't determine which one related to this video. Can you please advise which one is for this? Also, what's the link for the first video? I'd like to watch it. Thanks.

    • @VBAA2Z
      @VBAA2Z  3 роки тому

      Thanks Debbie. I will try to add links to Project ID going forward.
      For now, if you just need source code for this episode you can go with Project ID: 011. Else for all videos bundled go for Project ID - 010 UI UX UserForm - Series Package - All Episodes (1-18)
      Playlist.
      ua-cam.com/play/PLo0aMPtFIFDoF3QSS_GZUYoHCqLwEPB8p.html&pbjreload=102

    • @debbie6085
      @debbie6085 3 роки тому

      @@VBAA2Z Thanks Lung. 👌

    • @VBAA2Z
      @VBAA2Z  3 роки тому

      no probs.

  • @redhaakhund1271
    @redhaakhund1271 3 роки тому +1

    ❤️👍👍👍👍👍👍

    • @VBAA2Z
      @VBAA2Z  3 роки тому

      👍👍

    • @redhaakhund1271
      @redhaakhund1271 3 роки тому

      @@VBAA2Z can you plz check your email i sent you🙏🌹

  • @Kumaranmoljha
    @Kumaranmoljha 3 роки тому

    I have a macro enabled worksheet which saves the data as XML format using mail merge .Then i import the XML file in Tally manually with import data option. Now i am looking for a solution which would make the process automatic using Tally (“localhost:9000”) i.e. once i save the file as XML format, immediately the data should get imported in Tally without any manual process. Hope i explained my query properly. Thanks in Advance. Best Regards,

  • @wennychez5606
    @wennychez5606 3 роки тому +1

    Another good one. Thanks!

    • @VBAA2Z
      @VBAA2Z  3 роки тому +1

      Thank you too!