Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Move or Size Combo Box from forms toolbar With Cells
Hi :
I would like to create a combo box from the forms toolbar and move or size it with cells so that if the rows or columns containing the box are hidden, the box will be hidden also. Is there a way to do this in excel? Thanks |
#2
|
|||
|
|||
If you rightclick on the dropdown from the Forms toolbar, you can choose "format
control". Then on the properties tab, you'll see that "move and size with cells" isn't available. Is there some overwhelming reason that you can't use the Combobox from the Control toolbox toolbar? It supports that option. steve-o wrote: Hi : I would like to create a combo box from the forms toolbar and move or size it with cells so that if the rows or columns containing the box are hidden, the box will be hidden also. Is there a way to do this in excel? Thanks -- Dave Peterson |
#3
|
|||
|
|||
Thanks for your reply.
When I put in a combo box from the control tools toolbar, I see the box on the screen, but when I right click on the combo box and click on "Format Control" I see a window that has tabs for size, protection, properties, and web. I doesn't look like there is a place to input a range, choose a cell link, or choose the # of drop down lines. The reason i've been trying to do this with a forms tool bar is that if I right click on a forms combo box and go to format control, i get the tabs for Size, Protection, Properties, Web, and Control. I can go to control and choose input range, cell link, and drop down lines. Is there a way to do the same thing (choose input range and cell link) for a control tools combo box? Thanks again, Steve-o "Dave Peterson" wrote: If you rightclick on the dropdown from the Forms toolbar, you can choose "format control". Then on the properties tab, you'll see that "move and size with cells" isn't available. Is there some overwhelming reason that you can't use the Combobox from the Control toolbox toolbar? It supports that option. steve-o wrote: Hi : I would like to create a combo box from the forms toolbar and move or size it with cells so that if the rows or columns containing the box are hidden, the box will be hidden also. Is there a way to do this in excel? Thanks -- Dave Peterson |
#4
|
|||
|
|||
Rightclick on the combobox from the control toolbox toolbar, then click on
properties. You'll see lots more options that you can change. Two of them are .linkedcell and .listfillrange. Type in the addresses that you want to use (Sheet1!a1 and sheet2!A1:A10 for example). One of the differences is that the linked cell will actually contain the value of the combobox--not an index into that range. There's a .style property, too. You have two options--one is 0-fmStyleDropDownCombo which allows the user to type anything into the combobox. The other option is fmStyleDropDownList which forces the user to match what's in the dropdown list. Play around with .matchentry and you may even find you like this combobox better than the dropdown from the forms toolbar. ====== And just another thought. You may find using Data|Validation an even easier option to implement. Debra Dalgleish has some very nice notes if you've never used this feature befo http://www.contextures.com/xlDataVal01.html steve-o wrote: Thanks for your reply. When I put in a combo box from the control tools toolbar, I see the box on the screen, but when I right click on the combo box and click on "Format Control" I see a window that has tabs for size, protection, properties, and web. I doesn't look like there is a place to input a range, choose a cell link, or choose the # of drop down lines. The reason i've been trying to do this with a forms tool bar is that if I right click on a forms combo box and go to format control, i get the tabs for Size, Protection, Properties, Web, and Control. I can go to control and choose input range, cell link, and drop down lines. Is there a way to do the same thing (choose input range and cell link) for a control tools combo box? Thanks again, Steve-o "Dave Peterson" wrote: If you rightclick on the dropdown from the Forms toolbar, you can choose "format control". Then on the properties tab, you'll see that "move and size with cells" isn't available. Is there some overwhelming reason that you can't use the Combobox from the Control toolbox toolbar? It supports that option. steve-o wrote: Hi : I would like to create a combo box from the forms toolbar and move or size it with cells so that if the rows or columns containing the box are hidden, the box will be hidden also. Is there a way to do this in excel? Thanks -- Dave Peterson -- Dave Peterson |
#5
|
|||
|
|||
Thanks for your reply. That answered my question.
"Dave Peterson" wrote: Rightclick on the combobox from the control toolbox toolbar, then click on properties. You'll see lots more options that you can change. Two of them are .linkedcell and .listfillrange. Type in the addresses that you want to use (Sheet1!a1 and sheet2!A1:A10 for example). One of the differences is that the linked cell will actually contain the value of the combobox--not an index into that range. There's a .style property, too. You have two options--one is 0-fmStyleDropDownCombo which allows the user to type anything into the combobox. The other option is fmStyleDropDownList which forces the user to match what's in the dropdown list. Play around with .matchentry and you may even find you like this combobox better than the dropdown from the forms toolbar. ====== And just another thought. You may find using Data|Validation an even easier option to implement. Debra Dalgleish has some very nice notes if you've never used this feature befo http://www.contextures.com/xlDataVal01.html steve-o wrote: Thanks for your reply. When I put in a combo box from the control tools toolbar, I see the box on the screen, but when I right click on the combo box and click on "Format Control" I see a window that has tabs for size, protection, properties, and web. I doesn't look like there is a place to input a range, choose a cell link, or choose the # of drop down lines. The reason i've been trying to do this with a forms tool bar is that if I right click on a forms combo box and go to format control, i get the tabs for Size, Protection, Properties, Web, and Control. I can go to control and choose input range, cell link, and drop down lines. Is there a way to do the same thing (choose input range and cell link) for a control tools combo box? Thanks again, Steve-o "Dave Peterson" wrote: If you rightclick on the dropdown from the Forms toolbar, you can choose "format control". Then on the properties tab, you'll see that "move and size with cells" isn't available. Is there some overwhelming reason that you can't use the Combobox from the Control toolbox toolbar? It supports that option. steve-o wrote: Hi : I would like to create a combo box from the forms toolbar and move or size it with cells so that if the rows or columns containing the box are hidden, the box will be hidden also. Is there a way to do this in excel? Thanks -- Dave Peterson -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Move or Size Combo Box from forms toolbar With Cells
I need the combo box to adjust with the underlying cell, when I right click
on the combo box and then click on format control and go to properties the move and size with cell option is not a highlighted. What do I need to do to make this work? "steve-o" wrote: Thanks for your reply. That answered my question. "Dave Peterson" wrote: Rightclick on the combobox from the control toolbox toolbar, then click on properties. You'll see lots more options that you can change. Two of them are .linkedcell and .listfillrange. Type in the addresses that you want to use (Sheet1!a1 and sheet2!A1:A10 for example). One of the differences is that the linked cell will actually contain the value of the combobox--not an index into that range. There's a .style property, too. You have two options--one is 0-fmStyleDropDownCombo which allows the user to type anything into the combobox. The other option is fmStyleDropDownList which forces the user to match what's in the dropdown list. Play around with .matchentry and you may even find you like this combobox better than the dropdown from the forms toolbar. ====== And just another thought. You may find using Data|Validation an even easier option to implement. Debra Dalgleish has some very nice notes if you've never used this feature befo http://www.contextures.com/xlDataVal01.html steve-o wrote: Thanks for your reply. When I put in a combo box from the control tools toolbar, I see the box on the screen, but when I right click on the combo box and click on "Format Control" I see a window that has tabs for size, protection, properties, and web. I doesn't look like there is a place to input a range, choose a cell link, or choose the # of drop down lines. The reason i've been trying to do this with a forms tool bar is that if I right click on a forms combo box and go to format control, i get the tabs for Size, Protection, Properties, Web, and Control. I can go to control and choose input range, cell link, and drop down lines. Is there a way to do the same thing (choose input range and cell link) for a control tools combo box? Thanks again, Steve-o "Dave Peterson" wrote: If you rightclick on the dropdown from the Forms toolbar, you can choose "format control". Then on the properties tab, you'll see that "move and size with cells" isn't available. Is there some overwhelming reason that you can't use the Combobox from the Control toolbox toolbar? It supports that option. steve-o wrote: Hi : I would like to create a combo box from the forms toolbar and move or size it with cells so that if the rows or columns containing the box are hidden, the box will be hidden also. Is there a way to do this in excel? Thanks -- Dave Peterson -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Move or Size Combo Box from forms toolbar With Cells
It sounds like you used a dropdown from the Forms toolbar. It doesn't support
"move and size with cells". If you delete that dropdown and replace it with a combobox from the control toolbox toolbar, you'll have that option. mandy wrote: I need the combo box to adjust with the underlying cell, when I right click on the combo box and then click on format control and go to properties the move and size with cell option is not a highlighted. What do I need to do to make this work? "steve-o" wrote: Thanks for your reply. That answered my question. "Dave Peterson" wrote: Rightclick on the combobox from the control toolbox toolbar, then click on properties. You'll see lots more options that you can change. Two of them are .linkedcell and .listfillrange. Type in the addresses that you want to use (Sheet1!a1 and sheet2!A1:A10 for example). One of the differences is that the linked cell will actually contain the value of the combobox--not an index into that range. There's a .style property, too. You have two options--one is 0-fmStyleDropDownCombo which allows the user to type anything into the combobox. The other option is fmStyleDropDownList which forces the user to match what's in the dropdown list. Play around with .matchentry and you may even find you like this combobox better than the dropdown from the forms toolbar. ====== And just another thought. You may find using Data|Validation an even easier option to implement. Debra Dalgleish has some very nice notes if you've never used this feature befo http://www.contextures.com/xlDataVal01.html steve-o wrote: Thanks for your reply. When I put in a combo box from the control tools toolbar, I see the box on the screen, but when I right click on the combo box and click on "Format Control" I see a window that has tabs for size, protection, properties, and web. I doesn't look like there is a place to input a range, choose a cell link, or choose the # of drop down lines. The reason i've been trying to do this with a forms tool bar is that if I right click on a forms combo box and go to format control, i get the tabs for Size, Protection, Properties, Web, and Control. I can go to control and choose input range, cell link, and drop down lines. Is there a way to do the same thing (choose input range and cell link) for a control tools combo box? Thanks again, Steve-o "Dave Peterson" wrote: If you rightclick on the dropdown from the Forms toolbar, you can choose "format control". Then on the properties tab, you'll see that "move and size with cells" isn't available. Is there some overwhelming reason that you can't use the Combobox from the Control toolbox toolbar? It supports that option. steve-o wrote: Hi : I would like to create a combo box from the forms toolbar and move or size it with cells so that if the rows or columns containing the box are hidden, the box will be hidden also. Is there a way to do this in excel? Thanks -- Dave Peterson -- Dave Peterson -- Dave Peterson |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Move or Size Combo Box from forms toolbar With Cells
"Dave Peterson" wrote: It sounds like you used a dropdown from the Forms toolbar. It doesn't support "move and size with cells". If you delete that dropdown and replace it with a combobox from the control toolbox toolbar, you'll have that option. mandy wrote: I need the combo box to adjust with the underlying cell, when I right click on the combo box and then click on format control and go to properties the move and size with cell option is not a highlighted. What do I need to do to make this work? "steve-o" wrote: Thanks for your reply. That answered my question. "Dave Peterson" wrote: Rightclick on the combobox from the control toolbox toolbar, then click on properties. You'll see lots more options that you can change. Two of them are .linkedcell and .listfillrange. Type in the addresses that you want to use (Sheet1!a1 and sheet2!A1:A10 for example). One of the differences is that the linked cell will actually contain the value of the combobox--not an index into that range. There's a .style property, too. You have two options--one is 0-fmStyleDropDownCombo which allows the user to type anything into the combobox. The other option is fmStyleDropDownList which forces the user to match what's in the dropdown list. Play around with .matchentry and you may even find you like this combobox better than the dropdown from the forms toolbar. ====== And just another thought. You may find using Data|Validation an even easier option to implement. Debra Dalgleish has some very nice notes if you've never used this feature befo http://www.contextures.com/xlDataVal01.html Thanks this is the information I needed :) steve-o wrote: Thanks for your reply. When I put in a combo box from the control tools toolbar, I see the box on the screen, but when I right click on the combo box and click on "Format Control" I see a window that has tabs for size, protection, properties, and web. I doesn't look like there is a place to input a range, choose a cell link, or choose the # of drop down lines. The reason i've been trying to do this with a forms tool bar is that if I right click on a forms combo box and go to format control, i get the tabs for Size, Protection, Properties, Web, and Control. I can go to control and choose input range, cell link, and drop down lines. Is there a way to do the same thing (choose input range and cell link) for a control tools combo box? Thanks again, Steve-o "Dave Peterson" wrote: If you rightclick on the dropdown from the Forms toolbar, you can choose "format control". Then on the properties tab, you'll see that "move and size with cells" isn't available. Is there some overwhelming reason that you can't use the Combobox from the Control toolbox toolbar? It supports that option. steve-o wrote: Hi : I would like to create a combo box from the forms toolbar and move or size it with cells so that if the rows or columns containing the box are hidden, the box will be hidden also. Is there a way to do this in excel? Thanks -- Dave Peterson -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change font in a forms control combo box | Excel Discussion (Misc queries) | |||
Font Size for Forms ComboBox in Excel | Excel Worksheet Functions | |||
Forms Check Box Font Size | Excel Discussion (Misc queries) | |||
Forms Toolbar vs. Control Toolbox vs. Data Validation for drop dow | Excel Discussion (Misc queries) | |||
Stubborn toolbars in Excel | Excel Discussion (Misc queries) |