View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary Brown[_4_] Gary Brown[_4_] is offline
external usenet poster
 
Posts: 209
Default Using dialog box

Bob,
I've emailed you a 'Tips of the Week' that I have that, Hopefully, will
put you on the right track.
--
Hope this helps.
Gary Brown


"B~O~B" wrote:

I have 37 major categories that have 2 to 10 sub-categories for each
major. I am trying to create a dialog box that will use a €śCombo Box€ť
to list the major categories (was successful), and then use the data
from the major to output the Sub-categories in €śList box€ť.

I have created NAMED location for all of the 37 sub-categories€¦ I
have tried Vlookup, Indirect, offsets, etc.

Can someone tell where I am going wrong?