Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-10-2022, 02:27 AM
martincrus martincrus is offline Need vba code to listbox1 and cmd btn Windows 11 Need vba code to listbox1 and cmd btn Office 2016
Novice
Need vba code to listbox1 and cmd btn
 
Join Date: Dec 2022
Location: toongabbie
Posts: 3
martincrus is on a distinguished road
Default Need vba code to listbox1 and cmd btn

Dear experts



i have excel master data i want split ethic group by easy way iam seeking help

i have userform1 listbox fill data with A:A & group(Sementism/Non sementism) E:E col

i want split them with multi selection of names and click Command category its move to

with exact data.

for e.g
10 people in non sementism

if i select 5 people from non Sementism and click Maghreb of North Africa those data move to Genetic_Tree sheet
if i select 5 people and click Rest of All Non Sementism Only Non Sementism will move to Genetic tree sheet
if i click All Non Sementism all Non Sementism will move to Genetic tree sheet

like that for sementism

it show off if member move show rest of data only in listbox.
Attached Files
File Type: xlsm FJA.xlsm (45.3 KB, 4 views)
Reply With Quote
  #2  
Old 12-13-2022, 01:45 PM
martincrus martincrus is offline Need vba code to listbox1 and cmd btn Windows 11 Need vba code to listbox1 and cmd btn Office 2016
Novice
Need vba code to listbox1 and cmd btn
 
Join Date: Dec 2022
Location: toongabbie
Posts: 3
martincrus is on a distinguished road
Default

could help anyone?
Reply With Quote
  #3  
Old 12-14-2022, 04:56 PM
Guessed's Avatar
Guessed Guessed is offline Need vba code to listbox1 and cmd btn Windows 10 Need vba code to listbox1 and cmd btn Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

I don't know exactly what you want but it looks like you are looking to use VBA to perform tasks that can be done smarter with a power query, pivot table and slicers.

Are you familiar with those? If not, have a look at some instructional videos on youtube like this one to do the data merge
https://www.youtube.com/watch?v=M_jIsnksv7I

Once you have the data merged, the pivot table and slicers will be easy to implement
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #4  
Old 12-17-2022, 03:58 AM
martincrus martincrus is offline Need vba code to listbox1 and cmd btn Windows 11 Need vba code to listbox1 and cmd btn Office 2016
Novice
Need vba code to listbox1 and cmd btn
 
Join Date: Dec 2022
Location: toongabbie
Posts: 3
martincrus is on a distinguished road
Default

Can u help in VBA, becoz we hide sheet only userform shows data cant copy and paste data, thats why i need vba code
Reply With Quote
Reply

Tags
excel vba 2016

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need vba code to listbox1 and cmd btn List of ascii code of Character Symbols or code for all symbols used in Word SamDsouza Word VBA 3 03-12-2020 04:49 AM
Need vba code to listbox1 and cmd btn AutoOpen code to change date code to date text Legal Learning Center Word VBA 6 02-22-2020 02:24 PM
Need vba code to listbox1 and cmd btn vba code sue68 Word VBA 2 08-31-2017 10:41 PM
Need vba code to listbox1 and cmd btn Help with Code AJacLo Excel Programming 2 02-19-2017 03:57 PM
Need vba code to listbox1 and cmd btn VBA Code to search for field codes with certain text before the Field code and to change style welcometocandyland Word VBA 4 02-08-2017 06:53 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:46 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft