Tolgag,

I have noticed that your response often not in the correct place in my NG
reader, for instance this is listed as a response to my point, whereas it
really is in response to Gregor's return to your earlier point. Is this a
'function' of ExcelForum, or are you just responding to latest post, as I
find it misleading.

Just wondered.

Bob

"tolgag " wrote in message
...
Hi georgk

Don't put numbers in place of i.
Just paste the code to the Initialize event of your user form

Dim i as integer
For i = 3 to 200
Me.ComboBox1.AddItem Worksheets("Name of the Worksheet").Cells(i,1)
Next

CommandButton1_Click is the correct one, paste the code for Button 1 in
this event.

For Command2 paste the following code again to its click event :
Unhide Me


---
Message posted from http://www.ExcelForum.com/