Somebody help me

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Xico - 08 Feb 2005 13:45 GMT

Hi

I have a problem in Excel.
How can I call a sheet in a workbook using a combobox.

Thanks in advance

Reply to this Message

Charles Kenyon - 08 Feb 2005 14:45 GMT

Here is the help you requested. Try an Excel newsgroup.

Signature

Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

> Hi
>
> I have a problem in Excel.
> How can I call a sheet in a workbook using a combobox.
>
> Thanks in advance

Reply to this Message

IC - 08 Feb 2005 16:58 GMT

Worksheets(ComboBox1.Value).Activate

In future I would suggest you try microsoft.public.excel or
microsoft.public.excel.programming for excel/programming questions.

Ian

> Hi
>
> I have a problem in Excel.
> How can I call a sheet in a workbook using a combobox.
>
> Thanks in advance

Reply to this Message