First of all thank you for this valuable video/knowledge. I have tried this on my userform. It works!! But there is a problem. The problem that I face is that I have data above 50 rows. With the code that you have given in the video the userform gets all that, but can't scroll down. The scrollbar doesn't work. Is there a solution for it. I have tried to activate the scrollbar through VBA, but no success. Hope that you can help me. Thanks in advance.
Dear Sir, I am trying to build a DIAGNOSTIC CENTRE MANAGEMENT SOFTWARE in Excel userform VBA. In that I have a List box with 7 columns and over 1000 rows of data. I want your help in editing an individual cell of a column say column 7, multiple rows that are a part of a group i.e Biochemistry investigations in column 7 sfter selecting Biochemistry form a drop down list. This group Biochemistry contains about 500 rows. I should also be able to select all in the BIOCHEMISTRY group and set a uniform value for all those investigations in column 7 or for individual cells in column 7 I want to be able tro edit the column contents directly from the list box. Can you please help. Regards
How to make exe file setup of any VBA application? Can you please do that, suppose that on this program is given above make exe file. So that we will take exe file setup in pendrive and install any system.
![[TH] 2024 PMGC League | กลุ่มสีเหลืองวันที่ 1 | PUBG MOBILE Global Championship](http://i.ytimg.com/vi/I_FdxGT3WV4/mqdefault.jpg)
Thank you so match, Sir.
Wonderful
Very nice video sir
First of all thank you for this valuable video/knowledge. I have tried this on my userform. It works!!
But there is a problem. The problem that I face is that I have data above 50 rows. With the code that you have given in the video the userform gets all that, but can't scroll down. The scrollbar doesn't work. Is there a solution for it. I have tried to activate the scrollbar through VBA, but no success. Hope that you can help me. Thanks in advance.
Thanks for watching. If shave 50 above row better in put in frame no necessity increase user form height Avoid coding for user form height. Thankyou
Dear Sir, I am trying to build a DIAGNOSTIC CENTRE MANAGEMENT SOFTWARE in Excel userform VBA. In that I have a List box with 7 columns and over 1000 rows of data. I want your help in editing an individual cell of a column say column 7, multiple rows that are a part of a group i.e Biochemistry investigations in column 7 sfter selecting Biochemistry form a drop down list. This group Biochemistry contains about 500 rows. I should also be able to select all in the BIOCHEMISTRY group and set a uniform value for all those investigations in column 7 or for individual cells in column 7
I want to be able tro edit the column contents directly from the list box. Can you please help.
Regards
Please Watch. th-cam.com/video/bVngMfWylSg/w-d-xo.html
How to make exe file setup of any VBA application? Can you please do that, suppose that on this program is given above make exe file. So that we will take exe file setup in pendrive and install any system.
Dear sir I want to auto update userform without click any btn, when cells Value change. Is it possible?
ita really amazing but how to get print out
Dear Sir How to edit this Data through Userform .
How to update sir? Please help