Hide my combo boxes!

I have a form with some combo boxes and a group box at the bottom,
the combo boxes and group box are within the section that I want to hide, but when I select the rows to hide, the cells disappear but the group box and combo boxes don't .
Help!

Hi Hays4,

On the Toolbar click on the Design Mode icon, Right click combobox you want to disappear, in the dropdown click Properties now scroll down to Visible in the properties box and click False.

Go back up to the toolbar and click the design mode icon.

In order to see these again you will have to go back and change the visible property back to true.

Larry

For the comboboxes...

If you used a combobox from the control toolbox toolbar, you can right click on
it and choose Format control. On the properties tab, you can choose "Move and
size with cells".

If you used a dropdown from the Forms toolbar, then you'll notice that they
don't support this option.

Depending on what you're doing with that dropdown, you may want to look at using
Data|Validation.



hays4 wrote:
>
> I have a form with some combo boxes and a group box at the bottom,
> the combo boxes and group box are within the section that I want to
> hide, but when I select the rows to hide, the cells disappear but the
> group box and combo boxes don't .
> Help!
>
> --
> hays4
> ------------------------------------------------------------------------
> hays4's Profile: http://www.excelforum.com/member.php...o&userid=28069
> View this thread: http://www.excelforum.com/showthread...hreadid=482783

--

Dave Peterson

Hi Larry, thanks for your reply, I have tried what you suggested.
The combobox is selected, I click on the design mode icon (which, actually is already pressed down), but the properties box shows properties for the sheet, not the combobox. When I right click on the combo box there is no 'Properties' option, just the Format Control option and the usual cut/paste etc.
So, I can't seem to access the properties for each combo box to select visible=false as you suggested.

mmm..tricky

Hayley

Hi Hays4,

If your combobox is on a sheet, Daves reply will work for you.

Hi Dave,
yes you're right, I had created the combo box where the "move and size with cells" option is greyed out.
So I created another combo box the other way, but when I choose Format Control there's no control tab to specify all my options etc. So how do these kind of combo boxes work?
Hayley

The comboboxes from the control toolbox toolbar work differently.

First, click the Design Mode icon on that same control toolbox toolbar. Then
rightclick on the combobox. Choose properties.

You'll see lots more options that you can set here--including:
LinkedCell
ListFillRange
And Style (allow typing or just pick from list)

Notice that the linked cell doesn't return an index into that list--it actually
returns the value in the combobox.

=====
And you still may want to look at Data|validation. This is usually easier to
use then either the dropdown or combobox.

Take a look at Debra Dalgleish's site:
http://contextures.com/xlDataVal01.html

She has lots of tips and hints there.

hays4 wrote:
>
> Hi Dave,
> yes you're right, I had created the combo box where the "move and size
> with cells" option is greyed out.
> So I created another combo box the other way, but when I choose Format
> Control there's no control tab to specify all my options etc. So how do
> these kind of combo boxes work?
> Hayley
>
> --
> hays4
> ------------------------------------------------------------------------
> hays4's Profile: http://www.excelforum.com/member.php...o&userid=28069
> View this thread: http://www.excelforum.com/showthread...hreadid=482783

--

Dave Peterson