Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a UserForm based on Worksheet data
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a varying UserForm using cells from a hidden worksheet | Excel Programming | |||
Generating a Userform based on a worksheet | Excel Discussion (Misc queries) | |||
Add worksheet based on textbox/userform | Excel Programming | |||
Creating an array based on worksheet index | Excel Programming | |||
Creating a Data Entry Userform | Excel Programming |