Archive of Mr Excel Message Board


Back to Controls in Excel archive index
Back to archive home

ComboBox in a sheet, not in a UserForm?

Posted by Edgar on January 26, 2001 9:38 AM
Hello All:

I am trying to create a dropdown ComboBox in Sheet2 of my spreadsheet.
I want it to list only column A from a table called SPD2 which has a range
of Sheet1 A2:I31 and then I wanted the value selected from that ComboBox to
be inputed into Cell A10 on Sheet2. I was able to do this by entering a ComboBox
in a UserForm, specifying the RowSource in the properties to be the range from my table,
and then by using the following:

Worksheets("Sheet2").Range("A10") = UserForm1.ComboBox1.Value

I can't get this to work outside of the UserForm, please help. Am I overlooking something?


Re: ComboBox in a sheet, not in a UserForm?

Posted by cpod on January 26, 2001 2:32 PM


In the property list for your combo box just enter sheet2!a10 into the LinkedCell property.


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.