Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
combobox
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
combobox
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
combobox
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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
combobox
..Controlsource is the linked cell -- just one cell.
Try changing the .rowsource property. antonov wrote: 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? -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
combobox
ehmmm... sorry Dave but I didn't get that one....
I have 500 odds cells how can I refer to just one? "Dave Peterson" wrote in message ... .Controlsource is the linked cell -- just one cell. Try changing the .rowsource property. antonov wrote: 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? -- Dave Peterson |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
combobox
No, controlsource is a single cell where the selected value returns.
You need to set the Rowsource property to those 500 cells. -- HTH RP (remove nothere from the email address if mailing direct) "antonov" wrote in message .. . ehmmm... sorry Dave but I didn't get that one.... I have 500 odds cells how can I refer to just one? "Dave Peterson" wrote in message ... .Controlsource is the linked cell -- just one cell. Try changing the .rowsource property. antonov wrote: 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? -- Dave Peterson |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
combobox
It works, thanks guys
"Bob Phillips" wrote in message ... No, controlsource is a single cell where the selected value returns. You need to set the Rowsource property to those 500 cells. -- HTH RP (remove nothere from the email address if mailing direct) "antonov" wrote in message .. . ehmmm... sorry Dave but I didn't get that one.... I have 500 odds cells how can I refer to just one? "Dave Peterson" wrote in message ... .Controlsource is the linked cell -- just one cell. Try changing the .rowsource property. antonov wrote: 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? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fill combobox depending on selection from another combobox | Excel Discussion (Misc queries) | |||
combobox | Excel Discussion (Misc queries) | |||
How Do I Load A ComboBox RowSource From The Results Of Another ComboBox | Excel Programming | |||
Populating combobox from another combobox | Excel Programming | |||
combobox | Excel Programming |