| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ComboBox.RowSource?
Strange: When I draw a ComboBox on a UserForm, I can specify RowSource for
this control (to let it read data from a given range in a worksheet). However, when I draw a ComboBox directly in a worksheet, I don't see RowSource in the Properties-window. What's wrong? Any suggestions? br Jim |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ComboBox.RowSource?
Try a ControlBox Combobox instead
"JimAnAmateur" wrote in message ... Strange: When I draw a ComboBox on a UserForm, I can specify RowSource for this control (to let it read data from a given range in a worksheet). However, when I draw a ComboBox directly in a worksheet, I don't see RowSource in the Properties-window. What's wrong? Any suggestions? br Jim |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ComboBox.RowSource?
Jim
It's ListFillRange on the ActiveX control in Excel. The difference is because UserForms are part of Office rather than specific to Excel -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "JimAnAmateur" wrote in message ... Strange: When I draw a ComboBox on a UserForm, I can specify RowSource for this control (to let it read data from a given range in a worksheet). However, when I draw a ComboBox directly in a worksheet, I don't see RowSource in the Properties-window. What's wrong? Any suggestions? br Jim |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ComboBox.RowSource?
Thanks, Nick!
But, no matter what I write (in the field "ListFillRange"), it's just not recorded (the field gets empty right away). What is the syntax for this field? I tried e.g. "Sheet1!a1:a10" (with and without quotation marks), ... br Jim "Nick Hodge" skrev i melding ... Jim It's ListFillRange on the ActiveX control in Excel. The difference is because UserForms are part of Office rather than specific to Excel -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "JimAnAmateur" wrote in message ... Strange: When I draw a ComboBox on a UserForm, I can specify RowSource for this control (to let it read data from a given range in a worksheet). However, when I draw a ComboBox directly in a worksheet, I don't see RowSource in the Properties-window. What's wrong? Any suggestions? br Jim |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ComboBox.RowSource?
Jim, If you use the Control Toolbox to create your combo box, you will need
to be in design mode to access the properties box. Otherwise you can use the AddItem or List method to fill the box. If you use the Forms Toolbar to create the combo box then you will need to use the format control option on the Forms toolbar and on the Control tab you can specify the range for the row source and links. "JimAnAmateur" wrote: Thanks, Nick! But, no matter what I write (in the field "ListFillRange"), it's just not recorded (the field gets empty right away). What is the syntax for this field? I tried e.g. "Sheet1!a1:a10" (with and without quotation marks), ... br Jim "Nick Hodge" skrev i melding ... Jim It's ListFillRange on the ActiveX control in Excel. The difference is because UserForms are part of Office rather than specific to Excel -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "JimAnAmateur" wrote in message ... Strange: When I draw a ComboBox on a UserForm, I can specify RowSource for this control (to let it read data from a given range in a worksheet). However, when I draw a ComboBox directly in a worksheet, I don't see RowSource in the Properties-window. What's wrong? Any suggestions? br Jim |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ComboBox.RowSource?
Coza,
I don't find ControlTollbox. I am using Excel 2003. Where do I find it? br Jim "JLGWhiz" skrev i melding ... Jim, If you use the Control Toolbox to create your combo box, you will need to be in design mode to access the properties box. Otherwise you can use the AddItem or List method to fill the box. If you use the Forms Toolbar to create the combo box then you will need to use the format control option on the Forms toolbar and on the Control tab you can specify the range for the row source and links. "JimAnAmateur" wrote: Thanks, Nick! But, no matter what I write (in the field "ListFillRange"), it's just not recorded (the field gets empty right away). What is the syntax for this field? I tried e.g. "Sheet1!a1:a10" (with and without quotation marks), ... br Jim "Nick Hodge" skrev i melding ... Jim It's ListFillRange on the ActiveX control in Excel. The difference is because UserForms are part of Office rather than specific to Excel -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "JimAnAmateur" wrote in message ... Strange: When I draw a ComboBox on a UserForm, I can specify RowSource for this control (to let it read data from a given range in a worksheet). However, when I draw a ComboBox directly in a worksheet, I don't see RowSource in the Properties-window. What's wrong? Any suggestions? br Jim |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ComboBox.RowSource?
I used FormsToolbar first, since there is too little formatting facilities
on FormsToolbar (e.g., font size), I went over to using Control Toolbox. So: 1) with FormsToolbar I can specify the row source (as you wrote here), but not tthings like font face/size, ...? 2) with Control Toolbox I could change font face/size, but I (so far) seem not to be able to specify row source (or ListFillRange). br Jim "JLGWhiz" skrev i melding ... Jim, If you use the Control Toolbox to create your combo box, you will need to be in design mode to access the properties box. Otherwise you can use the AddItem or List method to fill the box. If you use the Forms Toolbar to create the combo box then you will need to use the format control option on the Forms toolbar and on the Control tab you can specify the range for the row source and links. "JimAnAmateur" wrote: Thanks, Nick! But, no matter what I write (in the field "ListFillRange"), it's just not recorded (the field gets empty right away). What is the syntax for this field? I tried e.g. "Sheet1!a1:a10" (with and without quotation marks), ... br Jim "Nick Hodge" skrev i melding ... Jim It's ListFillRange on the ActiveX control in Excel. The difference is because UserForms are part of Office rather than specific to Excel -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "JimAnAmateur" wrote in message ... Strange: When I draw a ComboBox on a UserForm, I can specify RowSource for this control (to let it read data from a given range in a worksheet). However, when I draw a ComboBox directly in a worksheet, I don't see RowSource in the Properties-window. What's wrong? Any suggestions? br Jim |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ComboBox.RowSource?
If you can change the font using the properties, then you should be able to see
listfillrange. It's about 7 entries below the font on the alphabetic tab. JimAnAmateur wrote: I used FormsToolbar first, since there is too little formatting facilities on FormsToolbar (e.g., font size), I went over to using Control Toolbox. So: 1) with FormsToolbar I can specify the row source (as you wrote here), but not tthings like font face/size, ...? 2) with Control Toolbox I could change font face/size, but I (so far) seem not to be able to specify row source (or ListFillRange). br Jim "JLGWhiz" skrev i melding ... Jim, If you use the Control Toolbox to create your combo box, you will need to be in design mode to access the properties box. Otherwise you can use the AddItem or List method to fill the box. If you use the Forms Toolbar to create the combo box then you will need to use the format control option on the Forms toolbar and on the Control tab you can specify the range for the row source and links. "JimAnAmateur" wrote: Thanks, Nick! But, no matter what I write (in the field "ListFillRange"), it's just not recorded (the field gets empty right away). What is the syntax for this field? I tried e.g. "Sheet1!a1:a10" (with and without quotation marks), ... br Jim "Nick Hodge" skrev i melding ... Jim It's ListFillRange on the ActiveX control in Excel. The difference is because UserForms are part of Office rather than specific to Excel -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "JimAnAmateur" wrote in message ... Strange: When I draw a ComboBox on a UserForm, I can specify RowSource for this control (to let it read data from a given range in a worksheet). However, when I draw a ComboBox directly in a worksheet, I don't see RowSource in the Properties-window. What's wrong? Any suggestions? br Jim -- Dave Peterson |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ComboBox.RowSource?
Jim
In the property enter Sheet1!$A$1:$A$10 No quotes but you need the absolute reference -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "JimAnAmateur" wrote in message ... Thanks, Nick! But, no matter what I write (in the field "ListFillRange"), it's just not recorded (the field gets empty right away). What is the syntax for this field? I tried e.g. "Sheet1!a1:a10" (with and without quotation marks), ... br Jim "Nick Hodge" skrev i melding ... Jim It's ListFillRange on the ActiveX control in Excel. The difference is because UserForms are part of Office rather than specific to Excel -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "JimAnAmateur" wrote in message ... Strange: When I draw a ComboBox on a UserForm, I can specify RowSource for this control (to let it read data from a given range in a worksheet). However, when I draw a ComboBox directly in a worksheet, I don't see RowSource in the Properties-window. What's wrong? Any suggestions? br Jim |
|
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ComboBox.RowSource?
Nick,
I did as you describe, but still, the field returned empty right away. I also did it in macro, e.g. ComboBox1.ListFillRange = "Sheet1!$A$1:$A$10", and it didn't work either (the list remains empty). More problems: ActiveX controls that I add on my sheet (TreeView, RichTextBox), no matter how I specify the size (both in properties-windows, and programmed in macro), they appaer as a little window (not the size I specified) on the sheet when I reopen the file. I do have a Sub that is called in Auto_Open, and that "re-draws" the controls on the sheet, but the controls remains "tiny" on the sheet. br Jim "Nick Hodge" skrev i melding ... Jim In the property enter Sheet1!$A$1:$A$10 No quotes but you need the absolute reference -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "JimAnAmateur" wrote in message ... Thanks, Nick! But, no matter what I write (in the field "ListFillRange"), it's just not recorded (the field gets empty right away). What is the syntax for this field? I tried e.g. "Sheet1!a1:a10" (with and without quotation marks), ... br Jim "Nick Hodge" skrev i melding ... Jim It's ListFillRange on the ActiveX control in Excel. The difference is because UserForms are part of Office rather than specific to Excel -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "JimAnAmateur" wrote in message ... Strange: When I draw a ComboBox on a UserForm, I can specify RowSource for this control (to let it read data from a given range in a worksheet). However, when I draw a ComboBox directly in a worksheet, I don't see RowSource in the Properties-window. What's wrong? Any suggestions? br Jim |
|
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ComboBox.RowSource?
I can't reproduce your problems.
This works for me programmatically: ActiveSheet.OLEobjects("ListBox2").ListFillRange = "Sheet1!A2:A11" Manually I can enter A2:A11 without absolute references, with or without the sheet name, and it works fine. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "JimAnAmateur" wrote in message ... Nick, I did as you describe, but still, the field returned empty right away. I also did it in macro, e.g. ComboBox1.ListFillRange = "Sheet1!$A$1:$A$10", and it didn't work either (the list remains empty). More problems: ActiveX controls that I add on my sheet (TreeView, RichTextBox), no matter how I specify the size (both in properties-windows, and programmed in macro), they appaer as a little window (not the size I specified) on the sheet when I reopen the file. I do have a Sub that is called in Auto_Open, and that "re-draws" the controls on the sheet, but the controls remains "tiny" on the sheet. br Jim "Nick Hodge" skrev i melding ... Jim In the property enter Sheet1!$A$1:$A$10 No quotes but you need the absolute reference -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "JimAnAmateur" wrote in message ... Thanks, Nick! But, no matter what I write (in the field "ListFillRange"), it's just not recorded (the field gets empty right away). What is the syntax for this field? I tried e.g. "Sheet1!a1:a10" (with and without quotation marks), ... br Jim "Nick Hodge" skrev i melding ... Jim It's ListFillRange on the ActiveX control in Excel. The difference is because UserForms are part of Office rather than specific to Excel -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "JimAnAmateur" wrote in message ... Strange: When I draw a ComboBox on a UserForm, I can specify RowSource for this control (to let it read data from a given range in a worksheet). However, when I draw a ComboBox directly in a worksheet, I don't see RowSource in the Properties-window. What's wrong? Any suggestions? br Jim |
|
#12
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ComboBox.RowSource?
Jim, when you enter the range in the properties box for ListFillRange do it
like this: a10:c18 No quotation marks, no dollar signs, no spaces, no nothin except the colon between the range references. The ListBox is automatically tied to the sheet you create it on so you don't need the sheet1! reference for the range. For sizing the controls, use the handles that you see when you right click on them. Just grab a node with your mouse pointer (cursor) and stretch the control to the size you want. "JimAnAmateur" wrote: Nick, I did as you describe, but still, the field returned empty right away. I also did it in macro, e.g. ComboBox1.ListFillRange = "Sheet1!$A$1:$A$10", and it didn't work either (the list remains empty). More problems: ActiveX controls that I add on my sheet (TreeView, RichTextBox), no matter how I specify the size (both in properties-windows, and programmed in macro), they appaer as a little window (not the size I specified) on the sheet when I reopen the file. I do have a Sub that is called in Auto_Open, and that "re-draws" the controls on the sheet, but the controls remains "tiny" on the sheet. br Jim "Nick Hodge" skrev i melding ... Jim In the property enter Sheet1!$A$1:$A$10 No quotes but you need the absolute reference -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "JimAnAmateur" wrote in message ... Thanks, Nick! But, no matter what I write (in the field "ListFillRange"), it's just not recorded (the field gets empty right away). What is the syntax for this field? I tried e.g. "Sheet1!a1:a10" (with and without quotation marks), ... br Jim "Nick Hodge" skrev i melding ... Jim It's ListFillRange on the ActiveX control in Excel. The difference is because UserForms are part of Office rather than specific to Excel -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "JimAnAmateur" wrote in message ... Strange: When I draw a ComboBox on a UserForm, I can specify RowSource for this control (to let it read data from a given range in a worksheet). However, when I draw a ComboBox directly in a worksheet, I don't see RowSource in the Properties-window. What's wrong? Any suggestions? br Jim |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combobox Rowsource | Excel Programming | |||
| Combobox rowsource | Excel Programming | |||
| How can Rowsource be used for a combobox on a form? | Excel Programming | |||
| How Do I Load A ComboBox RowSource From The Results Of Another ComboBox | Excel Programming | |||
| combobox rowsource | Excel Programming | |||
![JimAnAmateur[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
