Posted to microsoft.public.excel.programming

Corey[_4_] Corey[_4_] is offline

external usenet poster

Posts: 19

Combobox add large range of cells

I have placed a Combobox(ActiveX) on a worksheet(Sheet2), but now i want to
populate it will all the values(that are not blank) in Sheet3 between
range("A2:A25000").

How do i do this without manually do this:

Combobox1.Additem Sheet3.Range("A2").value
Combobox1.Additem Sheet3.Range("A3").value
.....
.....
and so on?

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
how to apply conditional formula over large range of cells	macasst	Excel Worksheet Functions	1	February 14th 11 10:50 PM
ComboBox for a range of cells	Malka	Excel Discussion (Misc queries)	2	February 16th 10 09:04 PM
How do I identify duplicated numbers in a large range of cells	gillman54	New Users to Excel	2	January 7th 09 08:27 PM
Populate Cells With Range Via ComboBox	BJ	Excel Programming	4	August 4th 08 09:24 PM
Combobox to determine text for a range of cells	Robbyn	Excel Programming	0	June 26th 06 03:18 PM

All times are GMT +1. The time now is 06:08 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us