Thanks for the help...but the combo boxes are still showing.

I'm using the combo boxes from Toolbox - forms

I'm not really sure how to use the Control Toolbox - Combo boxes


--
Juan Carlos


"Dave Peterson" wrote:

Oops.

It's Jacob, not Jakob.

Sorry Jacob.

Dave Peterson wrote:

Just to add to Jakob's response...

If you're using comboboxes from the control toolbox toolbar, you can rightclick
on each of them (while in design mode), choose Format Control.

Then on the Properties tab, you can choose "Move and Size with cells".

Then if your comboboxes are within the range being hidden, they'll hide, too.

Jakob's code included this line:
Ctrl.Placement = 1
This 1 is the equivalent of teh "move and size with cells". He could have used
Excel's VBA constant: xlMoveAndSize, too.

But his code does try change this setting for each control from the control
toolbox toolbar. You may not want all of them touched.

juancarlos wrote:

I"m using belog data to hide some rows. What can I add to information below
to hide the combo boxes within this rows?

Sub HideRowsBrazil()
If Rows("141").RowHeight = 0 Then
Rows("141:161").Hidden = False
Else
Rows("141:161").Hidden = True
End If
End Sub
--
Juan Carlos

--

Dave Peterson

--

Dave Peterson