Excel VBA - Linking 2 Combo Boxes

[Bhuktar S]

On a UserForm in Excel VBA I put 2 combo boxes.
Want to add list in combo box 1 (say, Rack1, Rack2, ....) by code (no
to use input from excel cells)
Similarly, want to add list for combo box2 (say, Item A1, Item A2, Ite
A3..... Item B1, Item B2, Item B3.....)
Only Item A1...A3 to appear in combo box2 for selection of Rack1 an
similarly, only Item B1...B3 to appear for Rack2 selection.
Help with code will be very much appreciated

 

[Bob Phillips]

Bhuktar,

Mail me direct for a working example that is easily adapted.

Note the anti-spam message at the foot of this message.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)