Posted to microsoft.public.excel.programming

Corey

external usenet poster

Posts: 276

ComboBox Row Source across ALL sheets

I am trying to setup a search across ALL sheets(sheet amount varies) to find
a MATCHED value in Cell D3.
I want the FIND ALL option to display ALL sheets that contain that value in
cell D3.

How can i enter the Row Source into the Combo Box to include ALL sheets from
just Sheet1?
Currently i have (=1!D3). BUT this ONLY searches Sheet"1" not ALL sheets int
he workbook.

Corey....

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Populate combobox from external source	John[_88_]	Excel Programming	0	December 1st 05 03:47 PM
Combobox and named range as source	Matt Jensen	Excel Programming	3	December 30th 04 02:47 PM
Combobox source	yohann	Excel Programming	1	March 6th 04 02:18 PM
combobox row source	scrabree	Excel Programming	1	October 15th 03 08:52 PM
Combobox list source	Chris Thompson	Excel Programming	3	August 26th 03 02:18 AM

All times are GMT +1. The time now is 12:48 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us