Hi al,

I have read reams on this over various forums and nothing I try seems to work. If someone could point me in the direction of a clear and concise tutorial on this subject or help me to understand where I am going wrong, It would be sincerely appreciated.

All I want to do is have one combobox within a userform - the options within which depend on the selection of another combobox.

Box 1 (cboNumber)Options are (1,2,3)
Box 2 (cboLetter)Options are (a,b,c if 1 is selected), (d,e,f if 2 is selected), (g, h, I if 3 is selected)

Ideally I would like to draw values from a worksheet named "Worksheet1", where 1,2,3 are "A2, A3, A4", a, b, c are column "B2, B3, B4", d, e, f are column "C2, C3, C4", etc. Frankly though, I don't care how it is done, I just want to understand how to do it.

I am very new to VBA and this issue is a small part of a larger form (most of which I have managed to accomplish using some fantastic tutorials out there). As such, please treat me like a simpleton and don't just fire some code at me on the assumption that I understand it or indeed know exactly where to place it.

Many thanks in advance of any help!