DEBLACKJACKAL
New Member
Hello everyone
Am Carlos by name, Kenyan by nationality and a fledgling programmer taking an increasing interest in Excel VBA. Am trying to create a simple user form that uses combo boxes to conduct the relevant search of data. I have attached a workbook named Staff Worksheet. In sheet 1 is a fictitious entry of staff employees in four columns namely Names, Gender, Age and Profession. In the User form I have designed, my intention is that should I for instance click the Name combo box and from the list displayed choose a name the matching name and relevant data ought to be displayed in the list box. The same thing ought to happen for the Gender and Profession combo boxes. I know it might not be that simple but I will appreciate any help in setting up the coding even if its for one combo box which will serve as a guide for the other remaining combo boxes.
Thanks
Am Carlos by name, Kenyan by nationality and a fledgling programmer taking an increasing interest in Excel VBA. Am trying to create a simple user form that uses combo boxes to conduct the relevant search of data. I have attached a workbook named Staff Worksheet. In sheet 1 is a fictitious entry of staff employees in four columns namely Names, Gender, Age and Profession. In the User form I have designed, my intention is that should I for instance click the Name combo box and from the list displayed choose a name the matching name and relevant data ought to be displayed in the list box. The same thing ought to happen for the Gender and Profession combo boxes. I know it might not be that simple but I will appreciate any help in setting up the coding even if its for one combo box which will serve as a guide for the other remaining combo boxes.
Thanks