Merry Christmas everyone. I hope God blesses you richly this upcoming year. Remember, you ARE a success!! Believe it, be it! Blessings my friends!! Dan
Another great tutorial. I'm starting to get these List Boxes! I use to be a VBA developer but it's been 15 years and I'm rusty bigtime. Your videos are great!
Hey Dan ~ I've been a subscriber for awhile and due to two rather large work projects I'm plugging in to your tutorials more intently. As a result I'm hearing you say things that 'seem' conceptually untrue. As an example, in this video you mention that changing the 'ListFillRange' to a named range, in this case 'MyDB' makes the ListFillRange dynamic? How is that? A named range without dynamic components just returns a static range object does it not? Hoping for help. Also, do you have a video showing how to 'dynamically' fill a combobox which is embedded on one sheet with a list created on another sheet? Thanks Dan ~
sir i have to input transaction 'id' numbers with format like KNST0001 in text box in userform and also increment by 1 every time i click submit button.please give me code or make a video to do this.i tried this code and is not working. txt_Tid1 = "KNST" & "@"(0001) For i = 1 To 1000 txt_Tid1 = txt_Tid1 + 1 Next i it is giving expected end of statement error.
Merry Christmas everyone. I hope God blesses you richly this upcoming year. Remember, you ARE a success!! Believe it, be it! Blessings my friends!! Dan
Another great tutorial. I'm starting to get these List Boxes! I use to be a VBA developer but it's been 15 years and I'm rusty bigtime. Your videos are great!
Thanks Raegan. I appreciate your comments! Dan
Thanks for taking the time to make this, it has helped me with a project.
Thanks for these helpful hints.
My pleasure!
Super welcome Alex!
Hey Dan ~ I've been a subscriber for awhile and due to two rather large work projects I'm plugging in to your tutorials more intently. As a result I'm hearing you say things that 'seem' conceptually untrue. As an example, in this video you mention that changing the 'ListFillRange' to a named range, in this case 'MyDB' makes the ListFillRange dynamic? How is that? A named range without dynamic components just returns a static range object does it not? Hoping for help. Also, do you have a video showing how to 'dynamically' fill a combobox which is embedded on one sheet with a list created on another sheet? Thanks Dan ~
please show me how to update data in listbox userform! thanks for your contribution!
Amazing. 🌟 🌟 🌟 🌟 🌟
Thanks a lot. 👍
great tutorial. thanks (y)
Not sure if I understand, Siow.
Great
My list box keep resizing on my workbook? any suggestions how to keep location and size?
How to show the table that fill with line?
I inserted an List box (ActiveX control) but it always resizes when I am closing and opening the file. How can I prevent that?
sir i have to input transaction 'id' numbers with format like KNST0001 in text box in userform and also
increment by 1 every time i click submit button.please give me code or make a video to do this.i tried this code and is not working.
txt_Tid1 = "KNST" & "@"(0001)
For i = 1 To 1000
txt_Tid1 = txt_Tid1 + 1
Next i
it is giving expected end of statement error.
Hi Sridhar,
Please check out this video I made on the topic. ua-cam.com/video/vGguMYmAd_c/v-deo.html
Thanks
Dan
Dear Sir,
May i have your email ?
I have some problem handle my database excel.
Thank you