Drop Down List in Inputbox
 

thank u

any idea how to creat combobox on a userform

yours


--
helmekk

-----------------------------------------------------------------------
helmekki's Profile: http://www.excelforum.com/member.php...nfo&userid=693
View this thread: http://www.excelforum.com/showthread.php?threadid=26628

Drop Down List in Inputbox
 

In the VBE, in the menu do Insert = Userform

the control toolbox will appear

click on the combobox. go to the userform and rubberband a rectangle where
you want the combobox.

Use the Userform_Initialize event to populate the combobox if the values in
the list will be dynamic, dependent on some other condition.

Private Sub Userform_Initialize()
Select Case Worksheets("sheet1").range("B9").Value
Case 100
combobox1.AddItem 3
combobox1.AddItem 6
Case 75
combobox1.Additem 4
combobox1.AddItem 2
end Select
end sub

or use whatever is appropriate to populate the combobox.

to enter the result in cell, use the controlSource property Sheet3!A5
for example.

If the userform is named Userform1 then you show it with

Userform1.show

as an example.

--
regards,
Tom Ogilvy


"helmekki" wrote in message
...

thank u

any idea how to creat combobox on a userform

yours
h


--
helmekki


------------------------------------------------------------------------
helmekki's Profile:
http://www.excelforum.com/member.php...fo&userid=6939
View this thread: http://www.excelforum.com/showthread...hreadid=266280