Combo Boxes - VB (maybe) and Sheet Linking

  • Thread starter Thread starter rhysduk
  • Start date Start date
R

rhysduk

Hi all,,

First post here so go easy!

How do i get a sheet in my workbook activated (shown) when i click on a
certain component in a Combo Box of mine ?

Do i have to use Macro's and / or Cell links ? If so how do i do it ?

regards,

Rhys
 
Yes, you would need a macro.

Assuming a combobox from the control toolbox toolbar

in design mode, double click on the combobox

in the resulting module

Private Sub Combobox1_Click()
Worksheets(Combobox1.Value).Activate
End Sub
 
Thanks, but that doesnt answer my question 100%

(No offense)

Any ideas? It seems i cant select the range for the combo box list to
display through this type of combo box...

Rhys
 
Right

1.)

Used a ComboBox from the Control Toolbox and put the Sub Script info
into it....

How do i select different pages from the drop down list ?
You can type the name of each sheet into the combobox feild but an
error comes up after each letter... on completion it works... need to
get rid of the error though!

2.)

Put the Sub - End Sub info into a macro and assigned the macro to a
combobox from the FORMS toolbar...

Gives me an error of Object Required and/or just takes me to my HOME
sheet..

Any ideas people..

Thanks,

Rhys
 
It sounds like this combo is on a worksheet.

Use the combobox from the controltoolbox, but go into design mode. Then right
click on the combobox and select properties.

Change the style to fmstyledropdownlist.

Now you'll have to use the mouse to select an exact match.
 
Back
Top