combobox selection to change cell range data

's Computer Specifications

This is probably very easy, I have a combobox that has 1-10, I would
like it where whatever I select in that combobox, lets say 5, the
range P5:P28 gets populated with 5 all of the way down. Thanks.

's Computer Specifications

Private Sub ComboBox1_Change()
With ComboBox1
If .ListIndex > -1 Then
Range("P5:P28") = .Value
End If
End With
End Sub

--

Regards,
Nigel
(E-Mail Removed)

<(E-Mail Removed)> wrote in message
news:afe295c0-75b1-47b7-9583-(E-Mail Removed)...
> This is probably very easy, I have a combobox that has 1-10, I would
> like it where whatever I select in that combobox, lets say 5, the
> range P5:P28 gets populated with 5 all of the way down. Thanks.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I change the active cell in a non contiguous range or selection?	ptroiano	Microsoft Excel Programming	0	8th Nov 2009 09:55 PM
How do I change cell color based upon data range within the cell?	=?Utf-8?B?Q2hyaXMgU2FuZGVycw==?=	Microsoft Excel Worksheet Functions	1	6th Mar 2006 08:59 PM
Macro to change list box input range based on selection made in another cell	Sue	Microsoft Excel Programming	3	7th Oct 2004 06:45 PM
How do I get a datagrid to register a data change from a custom control cell (combobox)?	=?Utf-8?B?bWV0YW1lZGlh?=	Microsoft Dot NET Framework Forms	0	7th May 2004 11:31 PM
How do I get a datagrid to register a data change from a custom control cell (combobox)?	=?Utf-8?B?bWV0YW1lZGlh?=	Microsoft C# .NET	0	7th May 2004 11:31 PM