Is there any way to have pre-formatted controls and form items (drop-down and
check boxes) appear when a certain value is input into a cell?

What I am trying to do is when a person enters a project name into column A,
a drop-down will appear in column B, and check boxes in column c.

I can place them there ahead of time, but the actual numbers of projects is
unknown.

Hi,

Try code like this in the Sheet1 (or whatever) object:

Private Sub Worksheet_Change(ByVal Target As Range)
Set isect = Application.Intersect(Target, Range("G19"))
If Not isect Is Nothing Then
Me.CheckBox1.Visible = True
End If
End Sub

This assumes that the Checkbox is named CheckBox1 and the cell where you
enter data is G19.
--
Cheers,
Shane Devenshire


"aeddave" wrote:

Is there any way to have pre-formatted controls and form items (drop-down and
check boxes) appear when a certain value is input into a cell?

What I am trying to do is when a person enters a project name into column A,
a drop-down will appear in column B, and check boxes in column c.

I can place them there ahead of time, but the actual numbers of projects is
unknown.