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

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


--
keithl816
------------------------------------------------------------------------
keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287
View this thread: http://www.excelforum.com/showthread...hreadid=482783

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


--
hays4
------------------------------------------------------------------------
hays4's Profile: http://www.excelforum.com/member.php...o&userid=28069
View this thread: http://www.excelforum.com/showthread...hreadid=482783

Hi Hays4,

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


--
keithl816
------------------------------------------------------------------------
keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287
View this thread: http://www.excelforum.com/showthread...hreadid=482783

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

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