Hello Bob:
I've created it. In ControlSource I've input =sheet3!a1:a500 but the return
message is: could not set the ControlSource porperty. Invalid property value
"Bob Phillips" wrote in message
...
Add a combobox from the forms toolbar, right-click to go to properties,
and
in the Control tab set the input range to A1:A500.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"antonov" wrote in message
.. .
My data is in sheet3 column A (1 to 500)
I need it to be visible in a combobox and also I would like the chosen
data
to be my result.... how can I do that?