J
James
Im trying to create a custom userform based off of data in a sheet. The way
the worksheet is layed out is as follows
Tag Name EngineType Shaft Combustion FuelType Etc.
Option1 e1,e2 only ALL C L
Option2 e1,e4,e5 CED S G
Option3 ALL HED S Dual
So basically this sheet tells you what "Tag Name" to use as a label on the
userform. This is achieved based on your criteria. So if I only want to see
all the e1/S options then this will tell me to use Opton2 & Option3.
Now, Question is what is the best way to select the appropriate Tag Name
based off of my criteria. I was thinking about using arrays but not too
familiar with them and havent used them in VBA. Im currently doing a series
of autofilters and working with the Visiblecells. Any feedback would be very
helpful. Thanks in advance
the worksheet is layed out is as follows
Tag Name EngineType Shaft Combustion FuelType Etc.
Option1 e1,e2 only ALL C L
Option2 e1,e4,e5 CED S G
Option3 ALL HED S Dual
So basically this sheet tells you what "Tag Name" to use as a label on the
userform. This is achieved based on your criteria. So if I only want to see
all the e1/S options then this will tell me to use Opton2 & Option3.
Now, Question is what is the best way to select the appropriate Tag Name
based off of my criteria. I was thinking about using arrays but not too
familiar with them and havent used them in VBA. Im currently doing a series
of autofilters and working with the Visiblecells. Any feedback would be very
helpful. Thanks in advance