PDA

View Full Version : VBA ComboBox



cherylinn
11-29-2012, 09:00 PM
Hi, I am trying to create a combo box to link the sheet page.
For example, i rename Sheet1 as "A" , Sheet2 as "B" and Sheet3 as "C" . User can click the combo box located on Sheet1 and choose other sheet they want to view. They will then automatically link to the sheet they choose. My question is how do i go about doing this ?

snb
11-30-2012, 01:42 AM
in the left down corner of the worksheet this 'combobox' is awaiting you, right click the mouse.

BrianMH
11-30-2012, 03:09 AM
Specifically right click the little arrows.