Forum

Need VBA help on us...
 
Notifications
Clear all

Need VBA help on userform popup with listbox values depends upon team select in combobox1

7 Posts
3 Users
0 Reactions
72 Views
(@crusadessword)
Posts: 4
Active Member
Topic starter
 

Hi experts

Hi experts

i am in need of help vba to show popup user form from select of team in combobox1

 

i have combo box sheet login i want user form's popup when i select team in combo box

 

Combo box in sheet Login

List box in user form1,2,3 (Afghanistan,Australia,Japan)

Raw data in Team sheet C:C Afghanistan,Australia,Japan team E:E is Status col

 

if i select JAPAN all japan team member and ground list need to popup in list box with active multiple selective option

 

find the attachment and jpeg image is expected result in listbox

 
Posted : 10/12/2022 10:19 pm
(@keebellah)
Posts: 373
Reputable Member
 

Maybe I'm missing it but ... which attachment?

 
Posted : 11/12/2022 3:09 am
(@crusadessword)
Posts: 4
Active Member
Topic starter
 

Please find the attachment

 
Posted : 11/12/2022 5:24 pm
Philip Treacy
(@philipt)
Posts: 1629
Member Admin
 

Hi Martin,

Still nothing attached.

Please read this and watch the video to see how to attach files.

Read This First | Forum Rules and Guides | Excel Forum (myonlinetraininghub.com)

Regards

Phil

 
Posted : 11/12/2022 10:58 pm
(@crusadessword)
Posts: 4
Active Member
Topic starter
 

EXPECTED-RESULT-IN-LISBOX.JPGI hope this time succeed at upload 

 
Posted : 12/12/2022 1:08 am
Philip Treacy
(@philipt)
Posts: 1629
Member Admin
 

Hi Martin,

You've attached an XLSX file so there's no VBA code or form in that to look at.  Can you please supply the XLSM file you are using.

Regards

Phil

 
Posted : 14/12/2022 6:51 pm
(@crusadessword)
Posts: 4
Active Member
Topic starter
 

Sorry it was not saved, I add userform with combobox and listbox where need to do action with combbox1 list out 3 Team Name,

if select Japan , listout only Japan data from rawdata sheet (B,C, and E) col only

 

installation of list box with multiselect option, move data to sheet report when select data and click command button

 
Posted : 21/12/2022 3:58 pm
Share: