Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Form Drop Down List
How do I enter values for the control source/row source
properties on a dropdown list on a VBA form in Excel. Help is no help! The only information I find is for worksheet dropdown lists. Everything I have tried (from strait text representing my desired values, text in quotes, worksheet references, etc.) gives me an error message that says "Can not set the ControlSource (or RowSource) property. Invalid Property Value.". I am sure it is a syntax problem, but I am not sure how to enter the necessary value. Thanks In Advance! Kevin |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Form Drop Down List
If you mean a ListBox in a UserForm, what you need to do is type the list in
some out-of-the-way range in your workbook. What I do is add a sheet, name it "Utility" and put my list there. Then name this list, say "TheList". Then, in the Properties of your ListBox, in the RowSource box, type "TheList" without the quotes. HTH Otto "Kevin" wrote in message ... How do I enter values for the control source/row source properties on a dropdown list on a VBA form in Excel. Help is no help! The only information I find is for worksheet dropdown lists. Everything I have tried (from strait text representing my desired values, text in quotes, worksheet references, etc.) gives me an error message that says "Can not set the ControlSource (or RowSource) property. Invalid Property Value.". I am sure it is a syntax problem, but I am not sure how to enter the necessary value. Thanks In Advance! Kevin |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Form Drop Down List
Thankyou!!!!
-----Original Message----- If you mean a ListBox in a UserForm, what you need to do is type the list in some out-of-the-way range in your workbook. What I do is add a sheet, name it "Utility" and put my list there. Then name this list, say "TheList". Then, in the Properties of your ListBox, in the RowSource box, type "TheList" without the quotes. HTH Otto "Kevin" wrote in message ... How do I enter values for the control source/row source properties on a dropdown list on a VBA form in Excel. Help is no help! The only information I find is for worksheet dropdown lists. Everything I have tried (from strait text representing my desired values, text in quotes, worksheet references, etc.) gives me an error message that says "Can not set the ControlSource (or RowSource) property. Invalid Property Value.". I am sure it is a syntax problem, but I am not sure how to enter the necessary value. Thanks In Advance! Kevin . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Form Drop Down List
Sheet3!A1:A10
-- Regards, Tom Ogilvy "Kevin" wrote in message ... How do I enter values for the control source/row source properties on a dropdown list on a VBA form in Excel. Help is no help! The only information I find is for worksheet dropdown lists. Everything I have tried (from strait text representing my desired values, text in quotes, worksheet references, etc.) gives me an error message that says "Can not set the ControlSource (or RowSource) property. Invalid Property Value.". I am sure it is a syntax problem, but I am not sure how to enter the necessary value. Thanks In Advance! Kevin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop-down list on simple excel 2003 form using "form" from data me | Excel Discussion (Misc queries) | |||
Printing a form with a drop down list | Excel Discussion (Misc queries) | |||
drop down list on form | Excel Discussion (Misc queries) | |||
User Form - Get Data From Drop List | Excel Discussion (Misc queries) | |||
Form drop down list | Excel Worksheet Functions |