Posted to microsoft.public.excel.programming

ca1358

external usenet poster

Posts: 37

ComboBox with horizontal range on an Excel USERFORM

Thank you!!!!!!!!!!!!
--
ca1358

"Dave Peterson" wrote:

dim myCell as range
dim myRng as range

set myrng = worksheets("sheet2").range("e2:h2")

With me.combobox3
for each mycell in myrng.cells
.additem mycell.value
next mycell
end with

ca1358 wrote:

How do you write a source in code in VB Code for a ComboBox3 on an Excel
UserForm where the source is horizontal range. For example Sheet2!E2:H2.
--
ca1358

--

Dave Peterson

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
ComboBox on a UserForm	LLoyd	Excel Worksheet Functions	2	February 20th 08 09:01 PM
Horizontal Input for Combobox	krais	Excel Discussion (Misc queries)	2	July 5th 06 07:37 PM
Userform w/ComboBox	D.Parker	Excel Discussion (Misc queries)	2	May 6th 05 04:28 PM
ComboBox on UserForm	Michel[_4_]	Excel Programming	3	August 1st 04 11:10 PM
ComboBox RowSource --- can I use a userform OWC10 spreadsheet range?	Dean Frazier	Excel Programming	0	February 11th 04 07:16 PM

All times are GMT +1. The time now is 07:00 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us