Menu

Combo Box Display

Search this Thread

#1

Report Post

Posted to microsoft.public.excel.misc

bob leathers bob leathers is offline

bob leathers is offline

external usenet poster

Posts: 7

Default

Combo Box Display

This worked Great!!!!!

Thanks

In article ,
says...
Option Explicit
Private Sub UserForm_Initialize()
Dim myCell As Range
For Each myCell In Worksheets("sheet999").Range("aa2:aa12").Cells
Me.ComboBox1.AddItem myCell.Text 'or format(mycell.value,"mm/dd/yyyy")
Next myCell
End Sub

And do the same thing with the times.

Reply With Quote

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
Combo Box Properties	Squeaky	Excel Discussion (Misc queries)	0	December 20th 06 03:44 PM
Using Drop Downs Or Combo Boxes to Look up and display Info	Wyveryn	Excel Discussion (Misc queries)	2	October 4th 06 02:43 AM
Combo Box	David French	Excel Worksheet Functions	0	October 3rd 05 06:02 PM
How do you display Greek and Russian languages in excel?	Mark Hayden	Excel Discussion (Misc queries)	1	August 1st 05 08:06 AM
how i choose the column from a combo box	Alberto Vargas	Excel Discussion (Misc queries)	4	July 22nd 05 11:07 PM

All times are GMT +1. The time now is 09:10 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement